Embedded OR, AND statements in an IF structure
 

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

Embedded OR, AND statements in an IF structure
 

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

Embedded OR, AND statements in an IF structure
 

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

WW

=Mass * (Speed_of_Light)^2? Course, that's only a theory. And in Excel
you'd have to define those names first.

Embedded OR, AND statements in an IF structure
 

Further to Zack's reply, you can use:

=EXP(1)

to return:

2.71828182845905

an approximation for e.

Hope this helps.

Pete

On Apr 21, 9:03*pm, W Wolfe wrote:
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

Embedded OR, AND statements in an IF structure
 

For your second question...

=EXP(1)

If you need it raised to a power other than 1, just put that value in the
parentheses.

Rick


"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