Just glad that you got it to work. Thanks got posting back.

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Stefania" wrote in message
...
Sandy,

Thank you!
You are a god!

I don't think I EVER would have got there!
--
Steffi
********
It''''s Thank You and Goodnight! :o) xx


"Stefania" wrote:

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