I'm not a secretary and I can't either grasp the fact that I would have to do it. I'm a programmer (among other things) and I would simply write a 'nested if'.
It's not totally elementary, indeed, but well within the grasp of a grain hauler, I should say. Just pronounce it as if ... then ... else if ... then ... else if ... then .... else ... and you'll understand it.
I need to write a formula that will automatically insert the correct information instead of flip flopping from one or the other. I haul farm grains and each one is a separate weight per bushel.
What I am searching for is something akin to this
IF A5 is SB then C5 is divided by 60
IF A5 is CR then C5 is divided by 56
IF A5 is WH then C5 is divided by 65
My wife is my secretary and cannot grasp the fact that she has to change the formula for each grain and thereby screws up my billing. Any advice will be appreciated