=IF hide result
Posted by Eddie Draper on January 26, 2002 6:47 AM
In my worksheet I need to determine stock levels.
I ask the question =IF (A1<10,"Order") But I only want the "Order" to appear in the cell when in stock level is less than 10.
Posted by Shams on January 26, 2002 7:28 AM
Try;
=IF(A1<10,"Order","")
In my worksheet I need to determine stock levels. I ask the question =IF (A1<10,"Order") But I only want the "Order" to appear in the cell when in stock level is less than 10.
Posted by eddiedraper@v21.co.uk on January 27, 2002 10:27 AM
Try; : : In my worksheet I need to determine stock levels. : I ask the question =IF (A1<10,"Order") But I only want the "Order" to appear in the cell when in stock level is less than 10.
