Excel 2010 - Multiple 'if' formula? 1

[dsmith910]

Hi

Is it possible to put more than one 'if' factor in one formula. My current formula says =IF(J84=0,"due",0) but I also want the cell to return zero if cell G84=0.

 

[GlennUK]

You can nest functions, or use OR or AND functions to combine logic. As a guess, I'd say this does what you want:

=IF(G84=0,0,IF(J84=0,"due",0))


Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[dsmith910]

Brilliant - that's exactly what I needed - works a treat!