vipaman
asked on
IF AND variables - guidance please.
I have 3 variables to check against, but some of them require other checks and I am getting lost. See file attached; this is a follow-on query and relates to rows 22-35. I have included in the spreadsheet an image of the calculations I am trying to automate. I believe i need to validate in the order i have labelled them in the image - 3 cases. In essence I am trying to derive an S value for the 3 cases. I haven't built Eq1 because i though i could build it into an IF statement but now i am not too sure. Hope this makes sense.
2nd-check.xlsx
2nd-check.xlsx
I've never used it but you might want to consider Matchcad.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
"addition and subtraction has higher priority then multiplication and division."
Isn't that backwards? 6*7+5*3 will be evaluated as (6*7) + (5*3).
Isn't that backwards? 6*7+5*3 will be evaluated as (6*7) + (5*3).
That’s correct. The order is
exponents and roots,
multiplication and division,
addition and subtraction.
exponents and roots,
multiplication and division,
addition and subtraction.
ASKER
Excellent!