Forum Discussion
Excel - 2 fields, always one of them needed to calculate
Hello, I want to calculate a torque, for that i need a force. The force is calculated with the mass and the acceleration of gravity. Is it now possible to give the user a opportunity to either fill i...
you can use IF to determine which formula to use.
=IF(AND(B2<>0;B6<>0;B4="");B2*B6*9,81;IF(AND(B2="";B4<>0;B6<>0);B4*B6;"");"INVALID ENTRY")
however you need to control all the probabilites. The IF formula will check the values on B2-B4 and B6 according to the values on these cells it will choose which formula to use. Otherwise it will display "INVALID ENTRY"