Thread: excell help
View Single Post
  #4  
Old 24th August 2004, 03:57 PM
sentabool sentabool is offline
Member
  
Join Date: Jan 1970
Location: Sydney
Posts: 10
Default
Try this in cell c2 - a nested if statement: -

=IF(AND(A2=1000,B2=1000),0,IF(AND(A2=1000,B2=1100) ,6,IF(AND(A2=1000,B2=1200),12,IF(AND(A2=1100,B2=12 00),6,""))))
Reply With Quote