Embedded OR, AND statements in an IF structure

[W Wolfe]

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?

 

[Zack Barresse]

For your first question, you could use ...

=IF(OR(A1>C1,B1>C1),500,IF(AND(D1>200,E1>200,F1>200),200,100))

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

=E1

 

[Spiky]

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

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

 

[Pete_UK]

Further to Zack's reply, you can use:

=EXP(1)

to return:

2.71828182845905

an approximation for e.

Hope this helps.

Pete

 

[Rick Rothstein \(MVP - VB\)]

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