
Andrea Milne
New Member
Members

Forum Posts: 2
Member Since:
January 10, 2021
January 10, 2021

Can someone help please, this is probably pretty simple however my knowledge is fairly basic.
At the moment there are no values in cells H6-H20, I would like cell H21 to remain blank unless a value is entered into any of the cells within the H6-20 range, once a value has been entered within the H6-H20 range I would like cell H21 to return the text POA. I have attempted below however does not work and returns a spill error.
=IF(H6="","",IF(H6:H20>0,"POA",""))
thanks in advance
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Karin Jongerius, Ayal Telem, TEJA P, James Dexter`
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
Hans Hallebeek: 185
Newest Members:
Kwaje Alfred Mogga
thong nguyen
Appiagyei Kofi Frimpong
Hilary Burchfield
Richie Wright
Adel Kock
Barbara Murray
Doug Milne
Siobhan Stringer
Rob Rooth
Forum Stats:
Groups: 3
Forums: 24
Topics: 6544
Posts: 28651
Member Stats:
Guest Posters: 49
Members: 32831
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —
