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

  Mark-335400 23:15 04 Dec 03
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 03

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

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

  pc moron 00:02 05 Dec 03

This seems to work.


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

  Stevie D 03:34 05 Dec 03

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 03

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.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now