IF problems

  • Thread starter Thread starter Amazon
  • Start date Start date
A

Amazon

I'm trying to work with a series of cells that calculate totals using the IF
logical argument. For the life of me I don't know why it's not working.
This is the scenario:
A1 = 500
B1 = 0
If B1 = 0 (or is blank, is that the same?),
then C1 = 0
If B1 >0 then C1= 600

In other words, if B1 is empty I don't want a value in C1. If B1 contains a
value, I want to add it to A1 and display it in C1. This is very vexxing,
because usually I just whip these out without a problem.

Would the fact I'm inserting this formula in C1 make a difference?

Thanks to all.
Hane
 
Amazon,

I don't undersatnd how you're getting 600 in C1 when A1 is 500???
If B1 = 0 (or is blank, is that the same?),
Click to expand...
No, they aren't.

Examples:
=IF(B1=0,"",A1+B1)
Will return a blank in C1 if B1 is either 0 or blank
=IF(B1="","",A1+B1)
will return a blank in C1 ONLY if B1 is blank (not 0)

John
 
Back
Top