Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

=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.

Check out our Excel Resources

Re: =IF hide result

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.

Re: =IF hide result

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.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.