When Value is present change phrase
ok so this is kind of a wierd question.. im going to be ebaying about 500 items over the next 5-6 months.. and i want to make a simple Spreadsheet that i can use to track what was listed and what wasnt.. and what was sold..
I have made a spread sheet.. and here is what i want to do
CODE STATUS ITEM COST S&H
X SOLD XXXXX XXXX XXX
So when i put X into CODE it says SOLD.. but when CODE is Empty i want it to say AVAILABLE If i put L in i want it to say LISTED..
I havent been able to find a proper IF statement for that.. lol Someone please let me know how i can make it work. .
Try
=IF(A1="X","Sold",IF(A1="L","Listed",""))
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel consulting, free examples and tutorials visit Excel Consulting-Excel VBA
Check out the free Excel Toolbar
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
Code Tags: Make your code easier for us to read
Worked great. how do i make it say "AVAILABLE" when there is no value present.. or i guess i could just add a third value to that.
IF =IF(A1="X","Sold",IF(A1="L","Listed","")) change to
=IF(A1="X","Sold",IF(A1="L","Listed",IF(A1="A","Available"""))
Although that argument does not work..
BTW.. thanks for that awesome quick response.. lol this just became my new favorite forum. lol
=IF(A1="X","Sold",IF(A1="L","Listed",IF(A1="A","Available","")))
Last edited by martindwilson; 03-20-2010 at 03:56 PM.
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
got it, the actual code was =IF(A2="X","Sold",IF(A2="L","Listed",IF(A2="A","Available,")))
Forgot to remove the last " . thanks for the quick response.. you guys are awesome.
btw any idea on how to add COLOR FILL As well
LIKE GREEN YELLOW AND RED..
Last edited by Edink1968; 03-20-2010 at 04:16 PM.
You can change colours using ConditionalFormatting,see
http://excel-it.com/excel_conditional_formatting.htm
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel consulting, free examples and tutorials visit Excel Consulting-Excel VBA
Check out the free Excel Toolbar
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
Code Tags: Make your code easier for us to read
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks