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
Bookmarks