LinkBack URL
About LinkBacks
Hey
I want to use this formula but I only want this formula to work if S3 is greater than 0
Can you help?
=IF(S3>=U3,"Yes","No")
Hey
I want to use this formula but I only want this formula to work if S3 is greater than 0
Can you help?
=IF(S3>=U3,"Yes","No")
What do you want to do with U3?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
here are two options
=IF(OR(S3>0,S3>=U3),"Yes","No")
or
=IF(AND(S3>0,S3>=U3),"Yes","No")
S3 and u3 have a number.Originally Posted by Sambo kid
The cell I want this formula to work in is to see if they have met their target.
So if s3 is greater or equal to u3 then I want to say yes met their target.
However I want to ignore any values of 0 is column S
Unfortunately these formulas do not work. Do I need to use an isserror formula?
so, this? =IF(S3=0,"",IF(S3>=U3,"Yes","No")) do you need to account for blanks?
if so then =IF(or(S3=0,s3=""),"",IF(S3>=U3,"Yes","No"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks