Thread: How do I get the IF function to work on more than one criterion?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stefania Stefania is offline
external usenet poster
  
Posts: 5
Default How do I get the IF function to work on more than one criterion?
Hi!

I'm writing a formula but I can't get my head around it.

The Formula below works:

=IF(EG8<2,IF(C8=1,ED8*Fees!D8,IF(C8=2,ED8*Fees!D18 ,IF(C8=3,ED8*Fees!D28,0))),0)

However I also need to add
IF(EG82<3,IF(C8=1,ED8*Fees!D9,IF(C8=2,ED8*Fees!D1 9,IF(C8=3,ED8*Fees!D29,0))))

and
IF(EG83<6,IF(C8=1,ED8*Fees!D10,IF(C8=2,ED8*Fees!D 20,IF(C8=3,ED8*Fees!D30,0))))

Am I asking too much or can it be done???

Thanks in advance for ANY kind of response!
----------

It's Thank You and Goodnight! :o) xx
Reply With QuoteReply With Quote