Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Display message based on condition
If A1 is less than B1 then display the message "Low stock" in C1
Anyone know the formula for this? Ta |
#2
|
|||
|
|||
=IF(A1<B1,"Low stock","")
Vaya con Dios, Chuck, CABGx3 "Pat" wrote in message ... If A1 is less than B1 then display the message "Low stock" in C1 Anyone know the formula for this? Ta |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to hide section of worksheet based on a condition (e.g. tick . | Excel Discussion (Misc queries) | |||
How do I hide a column based on a condition (option not available. | Excel Worksheet Functions | |||
make a cell empty based on condition | Charts and Charting in Excel | |||
Adding different validations based on condition | Excel Worksheet Functions | |||
Cannot sum values based on condition | Excel Worksheet Functions |