Sometimes, you just need a second set of eyes!I must of stared at the formula for an hour and to find something as stupid as that.... I appreciate you looking at it. I should have caught that.
I put the following formula in L1
=IF(J1="",0,IF(OR(K1="T","t"),J1*5000,IF(OR(K1="P","p"),J1*15572,IF(OR(K1="R","r"),J1*20000,0))))
J1 = 1
K1 = r
Result of the formula = #VALUE!
Not usre why.
Stapuff
No, shorter does not necessarily mean "quicker".Realistically does shorter represent "quicker"?