Okay now I need the column to say if the amount in c18 is 500.00 then put 20.00, but if c18 is 38.46 then put 38.46. When I enter the formula below, I get a "False" word or a "True" word and i need the 20.00 or 38.46 in that column????
Multiple If Statement not returning numbers - returning words
IF C18=500 (500=500.00) then result is 20 (or 20.00 depending on the cell format).
IF condition is not met then look at next statement.
Next statement: IF C18=38.46 then result is 38.46.
If condition is not met then result is "" (which stands for nothing or empty).
So result is either 20, 500 or nothing. False or zero are hereby eliminated.