Thread: If Statement
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
 
Posts: 1,240
Default If Statement

tss wrote:
Need help with this formula?
Need to calculate a formula for CELL A based upon the following
IF CELL B = STOCK and CELL C = 1.0, <25.0 THAN CELL D * 4


=IF(AND(B1="STOCK",C1=1,C1<25),D1*4,"**No idea what you want here**")

IF( AND( logical1, logical2, logical3 ), value_if_true, **value_if_false** )