Returning a "0" instead of a "FALSE" value

[TC123]

Hi,

I have the following formula, =IF(AND(ISBLANK(G8),ISBLANK(J8)),(K8-F8)*24*60) which works fine but if G8 and J8 are not blank it is returning a "FALSE" value. I would like it to return a 0 instead of FALSE. Does anybody know how to do this?

Thanks

 

[Mike Blackman]

Hi,

How about this?

=IF(AND(ISBLANK(G8),ISBLANK(J8)),(K8-F8)*24*60,0)

 

[Richard Schollar]

Hi

Insert your desired result in the 3rd argument space of the IF formula (ie the one returned if the conditional first argument returns FALSE:

=IF(AND(ISBLANK(G8),ISBLANK(J8)),(K8-F8)*24*60,0)

 

[B4L4KS]

hi

i have noticed that you have no value for false, so use below

=IF(AND(ISBLANK(G8),ISBLANK(J8)),(K8-F8)*24*60,0)

this has false as 0 so hope it works otherwise move it to appropriate place

kristian

 

[TC123]

Perfect! Thank you