Forum

Notifications
Clear all

My brain ISBLANK trying to figure out this simple problem

2 Posts
2 Users
0 Reactions
103 Views
(@Anonymous)
Posts: 0
New Member Guest
 

I am struggling to get the right formula right for the following please:

Column K = recent dates
Column V = date of birth
Column BH = =(K minus V divided by 365) ...to give age

Sometimes column V is not populated so BH gives the error #value

How do I add an IFBLANK or similar so that if V is empty then it puts a Zero as the result please?

Thanks

 
Posted : 21/05/2022 8:01 am
(@mynda)
Posts: 4762
Member Admin
 

Hi Gill,

Welcome to our forum!

Try this where your data is in row 2:

=IF(V2="",0,(K2-V2)/365)

Or

=IFERROR((K2-V2)/365,0)

 

Mynda

 
Posted : 21/05/2022 7:00 pm
Share: