Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF or IF(AND Function
Expiration /Date/Current Date/Status - Cenerio 1
# Required/# On Hand /Status Cenerio 2 Feb-06/ Jun-06 /ORDER/15/15/NO ORDER / indicate seperate cells I am trying to make a cell that indicates based off of the status of the cenerio 1 and 2, whether or not we need to order more of this product. As it is now based off of the expiration date from cenerio 1 it indicates whether or not we need to order more. and based off of how many we have on hand whether or not we need to order more of this product. But I want it to indicate based off of BOTH cenerios whether or not we need to order this product. How can I setup the spreadsheet to indicate this? |