Help

IF statement not working

Topic Labels: Formulas
Solved
Jump to Solution
774 3
cancel
Showing results for 
Search instead for 
Did you mean: 
PJ_Smith
4 - Data Explorer
4 - Data Explorer

I have the following formula which returns the correct amounts, except when engineer report is selected. In this case it comes up blank. All the other selections produce the expected numbers.

IF(Type=“Inspection”,“300”,IF(Type=“Estimate”,“30”,IF(Type=“Engineer Report”,50,IF(Type=“Photo Report”,“20”))))

Thanks

1 Solution

Accepted Solutions
Rey_Crisostomo
6 - Interface Innovator
6 - Interface Innovator

Maybe the phrase “Engineer Report” has slightly different spelling than the values in the Type column?

See Solution in Thread

3 Replies 3
Rey_Crisostomo
6 - Interface Innovator
6 - Interface Innovator

Maybe the phrase “Engineer Report” has slightly different spelling than the values in the Type column?

PJ_Smith
4 - Data Explorer
4 - Data Explorer

Thanks, sometimes it is the most simple issue. :rofl: :rofl:

On a side note, I noticed that the formula you listed is returning strings (quotes wrapped around the numbers) for all options except the “Engineer Report” option, which returns a number. Is that a typo in the way the formula was entered into your original message, or is that truly how the formula operates? Something tells me that it’s a bug at some level, as I’m guessing you want consistent data output: either all strings, or all numbers. If you’re running calculations using the result of the formula’s output, you’ll want numbers, so the quotes around those values should be removed.