Embedded OR, AND statements in an IF structure

  • Thread starter Thread starter W Wolfe
  • Start date Start date
W

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?
 
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
 
Also - Is there a function that returns the value of e?
Click to expand...

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

=EXP(1)

to return:

2.71828182845905

an approximation for e.

Hope this helps.

Pete
 
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
 
Back
Top