Forum

Notifications
Clear all

help with basic formula

3 Posts
2 Users
0 Reactions
128 Views
(@andrea-milne)
Posts: 2
New Member
Topic starter
 

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

 
Posted : 11/01/2021 5:42 am
(@andrea-milne)
Posts: 2
New Member
Topic starter
 

its ok I have worked it out as =IF(COUNT(H6:H20),"POA"," ")

 
Posted : 11/01/2021 6:24 am
(@sunnykow)
Posts: 1417
Noble Member
 

Possibly you can use COUNTA() instead of COUNT()

COUNTA() can handle text, numbers etc.

 
Posted : 11/01/2021 7:00 am
Share: