For your first question, you could use ...

=IF(OR(A1C1,B1C1),500,IF(AND(D1200,E1200,F120 0),200,100))

For your second question... what do you mean "value of e"? You mean value
of E1?....

=E1

--
Zack Barresse
Microsoft MVP (Excel)



"W Wolfe" wrote in message
...
I need to write a function that goes as follows:

IF A or B C, Then A1 = 500, Else IF D and E and F 200, the A1= 200,
Else
A1 = 100. Any suggestions?

Also - Is there a function that returns the value of e?
--
Thanks,

WW