Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Multiple If Statement not returning numbers - returning words [Closed]

Report
Posts
4
Registration date
Monday May 13, 2013
Status
Member
Last seen
May 13, 2013
 -
Posts
2742
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 4, 2021
 -
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????


=IF(C18<38.46,"38.46",IF(C18>"38.46",20))

3 replies

Answer 1 / 3
Posts
2742
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 4, 2021
 460
Hi Shaynajr,

If C18 is either 38.46 or 500.00 then your first statement (If C18<38.46) will never be true.

I don't see why you would get the word True, but the word False appears because your second IF formula doesn't contain a False statement.

Your formula should look like:
=IF(C18=500,20,IF(C18=38.46,38.46,""))

Hopefully the IF formula makes more sense now.

Best regards,
Trowa
Answer 2 / 3
Posts
4
Registration date
Monday May 13, 2013
Status
Member
Last seen
May 13, 2013
I need the number 20.00 to appear if cell c18 = to 500.00 or if 38.46 appears in cell c18 I need 38.46 to appear (need to eliminate the word false or zero)
Answer 3 / 3
Posts
2742
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 4, 2021
 460
And that is exactly what the above formula does.

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.
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!