Need Help with an Excel Formula!
one way.......
=IF(AND((B7+B8)0,(B7*B8)=0),15,IF(AND(B70,B80), 30,0))
--
Greetings from New Zealand
"m4d Ir15h" wrote in message
...
I have been trying to work on this for a while... and I hope I can get some
help.
basically, what I am working on is a type of checker.
Here is what I have come up with...
=IF((OR(B7=1,B8=1)),"15.00","00.00")
basically, this states that if there is something in B7 then, it would add
$15.00... or if there is something in B8, then it would also add $15.00,
which is great. But what I need that formula to basically do is the
following:
B7 with a value greater than Zero and b8 = Zero, add $15.00
B8 with a value greater than Zero and b7 = Zero, add $15.00
B8 AND B7 has a value greater than Zero, add $30.00
Get what I mean?
|