Trying to use the IF function in cell D1:
If C1 is greater than 3 or blank return "" but if less than 3 then return "Buy new". Cell C1 has a formula in it and when equal to zero returns a minus sign (will only have a number, be blank or have a minus sign -).
The formula below wont work when J17 has a - sign, please advise what will:
=IF(C1>3,"Buy new","")
Help appreciated
If C1 is greater than 3 or blank return ""
so thats C1>3, ""
not as you have
=IF( OR(C1>3, C1=""), "", "Buy New")
not sure what J17 has to do with the formula - can you exaplain please
is that because J17 is referenced in a formula in C1
perhaps a spreadsheet attached would help
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or may be this.....
If this is not what you are looking for, please upload a sample workbook as suggested by etaf.
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Etaf/ sktneer - you guys are legends, thanks for the help. The J17 is the actual location in my sheet which I tried to simplify for my post but didnt review it properly - Idiot!!
Tks again for help.
Glad to help you. Thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks