I am trying to create a function that will return the word YES if a discount is applicable and the word NO if a discount is not applicable.
In the sheet Winter -- Trip A, F6 should say YES because G6 is greater than 4. However, it is returning with NO. This is very important as it determines whether a member is required to pay the discounted amount or full price.
Winter -- Trip A, F6:
I really need to sort this out. This excel file is going to take a lot of work because there is a lot of references to other sheets. I'm determined to get it to work correctly though.
Any help is greatly appreciated!
Bookmarks