LinkBack URL
About LinkBacks
Hello,
How do I write a formula that will yield the following results? Thanks in advance!
Test 1 29% = Yes
Test 2 51% = No
If 50 % or below = Yes
If over 50 % = No
Hello,
How do I write a formula that will yield the following results? Thanks in advance!
Test 1 29% = Yes
Test 2 51% = No
If 50 % or below = Yes
If over 50 % = No
Last edited by Tashia; 03-17-2009 at 10:05 AM.
Could probably use a little more information, I'm not sure exactly what you are trying to do.
Replacing "Cell" with whichever cell has the value you want Excel to look at.
=IF(Cell <= 50, "Yes", No")
Does this work for you?
Last edited by jvegastn; 03-16-2009 at 03:37 PM. Reason: Fix't
Sorry, the formula is not working.
look at the example.
modytrane
Hi Tashia,
You need to tell us what cell the test result is in.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Hi,
I've attached a sample and copied the formulas as suggested. I'm not sure what I am doing wrong.
Thanks for the help!
In this case use your % sign.=IF(G18 <= 50%,"No","Yes")
Perfect! Thanks for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks