# IF Function Not Working Correctly(Regarding the > symbol)

1. ## IF Function Not Working Correctly(Regarding the > symbol)

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:
``Please Login or Register  to view this content.``
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!

2. ## Re: IF Function Not Working Correctly(Regarding the > symbol)

Is G6 formatted as a number... select it (or the column) and go to Data|Text to columns and click Finish... Then make sure the cell(s) are formatted as General or Number...You probably don't need SUM(G6:G6) though and it should probably just be =IF(G6>4,"YES","NO")

3. ## Re: IF Function Not Working Correctly(Regarding the > symbol)

It is returning with FALSE. Is there a reason why it isn't returning with NO?

4. ## Re: IF Function Not Working Correctly(Regarding the > symbol)

You have the same formula repeated 3 times in that cell... expand the formula bar to see, and remove 2 of them.

5. ## Re: IF Function Not Working Correctly(Regarding the > symbol)

Originally Posted by NBVC
You have the same formula repeated 3 times in that cell... expand the formula bar to see, and remove 2 of them.
Thank you! I am usually pretty good with different software applications. However, excel is another world to me when it comes to using formulas as I hardly use it.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1