I am using this formula in a spreadsheet =IF(AND(A2<>"",K2<>""),"CLOSED",IF(A2="","TO BUY","TO SELL"))
When the line is empty, the cell with this formula in displays "TO SELL". I would like it to display CLOSED until something is entered in either A2 (when it would display "TO SELL") or when something is entered in K2 (when it would display "TO BUY").
Any help on adjusting this formula would be appreciated.
Thanks,
Ant
Looks like you have the structure correct, but you should change both cases of <> to =
That nearly works but I need it to display closed if both A2 and K2 have something entered. In this case it displays TO SELL when both cells have something in.
you may have to further define your other parameters such as K2 and what you want done with the last section about A2 = "" and to buy or to sell.
something like this can work but I don't know what to do about the last part...
=IF(A2="","closed",IF(AND(A2<>"",K2<>""),"closed",IF(A2="","to buy","to sell")))
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
who are you replying to?
Let's do this, there are 4 possible combinations of the 2 cells..
A2 is blank AND K2 is blank, I want ??
A2 is blank AND K2 is NOT blank, I want ??
A2 is NOT blank AND K2 is blank, I want ??
A2 is NOT blank AND K2 is NOT blank, I want ??
I was replying to Jonmo sorry.
Jonmo:
A2 is blank AND K2 is blank, I want - CLOSED
A2 is blank AND K2 is NOT blank, I want - TO BUY
A2 is NOT blank AND K2 is blank, I want - TO SELL
A2 is NOT blank AND K2 is NOT blank, I want - CLOSED
this seems to work based on post #7 =IF(AND(A2="",K2=""),"closed",IF(AND(A2<>"",K2<>""),"closed",IF(AND(A2="",K2<>""),"to buy","to sell")))
Try
=IF(OR(AND(A2="",K2=""),AND(A2<>"",K2<>"")),"Closed",IF(A2="","To Buy","To Sell"))
Jonmo1, I like yours better, cleaner.
I kept fiddling with the or and part but didn't parse it like you did.
EDIT: and thanks antmcg12 for adding to my reputation.
Both of those work perferctly! Thanks Jonmo and Sambo.
Based on the title, you want these results (Closed, To Sell, etc.) to appear in A2 unless you enter something into A2 (plus other criteria). You cannot have both a formula and a manual entry in the same cell. (You can but once you put in the manual entry, the formula is gone for good). Am I reading this wrong?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
antmcg12 
Register To Reply
Bookmarks