| OT:What IF [message #12601] |
Tue, 08 April 2003 14:01  |
Boink-Your-Dead
Messages: 10
Registered: February 2003
Location: the uk.
Karma: 0
|
Recruit |
|
|
Ok I know this is nothing to do with Renegade but I saw a post on a homework question b4...
OK I suck at all things microsoft including excel...
I am supposed to do a what if statment...
I have the formula in d4 and I would like it to say out of stock if the value in d3 is 0 and say in stock if it is above 0....
Thank you for your healp.
-Boink-Your-Dead
BoinkYourDead@Hotmail.com
=======================
Final Fantasy X - The Best Game Ever
Link Park - In The End - The Best Song Ever
|
|
|
|
| OT:What IF [message #12642] |
Tue, 08 April 2003 15:46  |
snipefrag
Messages: 291
Registered: February 2003
Location: UK, hampshire
Karma: 0
|
Recruit |
|
|
This would go in you cell D4 (where you want the "in Stock" displayed.
=IF(D3>0,"In Stock","Out of Stock")
> means greater than, so if it is greater than 0 it will show "in stock" (,) if otherwise Show "out of stock"
The Comma means if not then
I have just done a 210 page IT project about Excel for A level if you have any queries then post here, Pm me or e-mail me at chett2001@hotmail.com.
Happy to help 
Snipefrag - Br20 Cr5 - TR Emerald
Planetside Chapter Commander - Archangels
http://www.archangelsclan.net
|
|
|
|
Search
Help
Members
Register
Login
Home
