| OT:What IF [message #12642] |
Tue, 08 April 2003 15:46  |
snipefrag
Messages: 291
Registered: February 2003
Location: UK, hampshire
Karma:
|
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
