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"))
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?
Help Article Resources
Check out the Formula Handbook template!