Hey,
I want a IF statement to contact 3 outcomes.
This is what I'm using at the moment:
=IF([@[Rounded Price]]<=[@Price],"Ok","Better")
So I'm comparing to prices.
If the price is the same I'd like it to say 'Same', if it's better then 'better' and if it's worse then 'worse'.
How do I do this?
Any help appreciated.
Thanks,
Ben
Bookmarks