Thread: Multiple IFs
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default Multiple IFs
Try
=IF(AND(J110,J1<25),"1",IF(AND(J125,J1<50),"2",I F(J150,"3"))

I

"WannaM" wrote in message
...
I need to display the result of multiple IFs
if (J110<25) "1", if (j125<50), "2", if (j150), "3"-
Driving me mad...anybody help please?


Reply With QuoteReply With Quote