Symbols not Resulting from Formula
I am trying to do a three-way match of dollar amounts in 3 different cells.
I have the formula set to a column using the Yes, Hold, No Decisions symbols. Here is the formula:
=IF([Requisitioned Amount]@row <> [PO Amount]@row, "no", IF([PO Amount]@row <> [Invoice Amount]@row, "no", "yes"))
Two Challenges
1) My symbols are not appearing, despite choosing them. I have the symbols working in other sheets and compared the formula, and I can't see where I've gone wrong. I'm sure I'm overlooking something obvious!
2) is there a way for me to write the formula so if the PO Amount, Requisitioned Amount or Invoice Amount are missing that the "Hold" symbol appears?
Answers
-
Outputting a symbol via formula is case sensitive.
Try this...
=IF([Requisitioned Amount]@row <> [PO Amount]@row, "No", IF([PO Amount]@row <> [Invoice Amount]@row, "No", "Yes"))
-
Ugh! I knew it was something easy I was overlooking. I won't forget this now.
Do you have any thoughts on the 2nd part of my question?
Is there a way for me to write the formula so if the PO Amount, Requisitioned Amount or Invoice Amount are missing that the "Hold" symbol appears?
Thank you!
-
Sure thing. Sorry I missed it.
=IF(OR([PO Amount]@row = "", [Requisitioned Amount]@row = "", [Invoice Amount]@row = ""), "Hold", IF([Requisitioned Amount]@row <> [PO Amount]@row, "No", IF([PO Amount]@row <> [Invoice Amount]@row, "No", "Yes")))
-
Thank you so much -- that worked
-
Help Article Resources
Categories
Check out the Formula Handbook template!