Symbols not Resulting from Formula

Donna T

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?

Paul Newcome

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"))

Donna T

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!

Paul Newcome

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")))

Donna T

Thank you so much -- that worked

Paul Newcome

Happy to help. 👍️