Help with an Excel "IF" and "AND" query

  Mark-335400 23:15 04 Dec 2003
Locked

Can't seem to get my head around this one (perhaps it's late).... scenario is like this....
I need to get either a "blank" or "zero" in cell AD8, by way of looking at AD4, if this is blank then blank in AD8, however if AD4 isn't blank BUT AD5 is "0" then I need AD8 to also show "0", BUT if AD4 isnt blank and AD5 isn't zero then I need AD8 to DIVIDE AD7 by AD6

Would appreciate any help on this matter

  VoG II 23:26 04 Dec 2003

Something like ( Whisperer can do better than m=e at formulas):

=IF (AD4="", "", if AD5 <>0, A7/D6))

  pc moron 00:02 05 Dec 2003

This seems to work.


=IF(AND(A4<>"",A5<>0),A7/A6,IF(AND(A4<>"",A5=0),0,""))

  Stevie D 03:34 05 Dec 2003

If the above don't help try this:

=IF(AD4="","",IF(AND(AD4<>"",AD5=0),0,IF(AND(AD4<>"",AD5<>0),AD7/AD6)))

  Mark-335400 07:31 05 Dec 2003

Thanks all for the replies, sorry I didn't reply, but the clue was in my posting (I fell asleep), anyway its now 7.35am and I will put the replies to the test when I get work in the next hour,,, will post the outcome later today.
Many Thanks for your replies

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Moto G6 Play Review: First Look

iPad 9.7in (2018) review

Test : les écouteurs Bluetooth Honor xSport AM61