Multiple If Statement not returning numbers - returning words
Closed
Shaynajr
TrowaD
- Posts
- 4
- Registration date
- Monday May 13, 2013
- Status
- Member
- Last seen
- May 13, 2013
TrowaD
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Related:
- Multiple If Statement not returning numbers - returning words
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Forum - Excel
- How to re/name a cell if another cell contains X ✓ - Forum - Excel
- Multiple if statements in excel data validation - Forum - Excel
- Multiple if statements in excel - Guide
- Multiple IF statements in Excel ✓ - Forum - Excel
3 replies
TrowaD
May 13, 2013 at 12:24 PM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
May 13, 2013 at 12:24 PM
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
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
Shaynajr
May 13, 2013 at 12:27 PM
- Posts
- 4
- Registration date
- Monday May 13, 2013
- Status
- Member
- Last seen
- May 13, 2013
May 13, 2013 at 12:27 PM
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)
TrowaD
May 14, 2013 at 11:16 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
May 14, 2013 at 11:16 AM
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.
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.