Help required with IF functions - adding an extra variable and outcome

Hi there,

I am currently using excel to make a utility for some University coursework. I need a set of results displayed based on a number entered by the user.

I am currently using this function

=IF(OR(B5>15000,ISTEXT(B5)),"invalid entry",1013.25*((B9/288.15)^(8.91/(0.0065*287))))

This works well, however I need the cell to perform a different calculation when the value in B5 is above 11000. How would I change my current function to do that?

thanks,

Joe

Originally Posted by Ace_XL

Try

=IF(OR(B5>15000,ISTEXT(B5)),"invalid entry",IF(B5>11000,diff_calculation,1013.25*((B9/288.15)^(8.91/(0.0065*287)))))

That worked perfectly! Thank you!