Thread: Multiple IF/AND/OR statments
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Zakynthos Zakynthos is offline
external usenet poster
  
Posts: 115
Default Multiple IF/AND/OR statments
What would be the format of the IF/AND/OR nested statement to return the
following:


If R1 contains a 9 and S1 contains a 36 I want a 4 in T1

If R1 contains a 7 and S1 contains a 36 I want a 5 in T1

If R1 contains a 6 and S1 contains a 30 I want a 5 in T1

If R1 contains a 5 and S1 contains a 25 I want a 5 in T1

If R1 contains a 6.25 and S1 contains a 25 I want a 4 in T1

If R1 contains a 5 and S1 contains a 20 I want a 4 in T1

If R1 contains a 4 and S1 contains a 20 I want a 5 in T1

Many thanks for your help

















Reply With QuoteReply With Quote