Ack! Excel N00b Needs help!

  • Thread starter Thread starter m4d Ir15h
  • Start date Start date
M

m4d Ir15h

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?
 
You've reached a newsgroup dedicated to supporting Microsoft Access, the
relational database product. Try posting to an Excel-specific newsgroup.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
This should do the trick!
=IF(OR(AND(B7>0,B8=0),AND(B8>0,B7=0)),15,0)

You may need to adjust it slightly if you want it to treat nulls as 0.
=IF(OR(AND(B7>0,OR(B8=0,B8="")),AND(B8>0,OR(B7=0,B7=""))),15,0)
 
Back
Top