Is there any more info to understand the calculations we can do? I saw the video and was trying to figure out some of the madness in it. I am trying to calculate commissions based on specific dollar amounts…Any usefull help would be appreciated!
I am including an image of what I am striving for…
Attachments:
You must be
logged in to view attached files.
Hi Kirk,
Your formula won’t work as is. The first problem I see is you’ve told the formula to return a Number. But your IF statement is returning Text. You should remove those quotes from the return value.
Also I’m assuming “Price of Stitch” is a Number value? If so, you shouldn’t compare it to $999. You should compare it to just 999 (without the $ prefixed to it).
As you scroll through the formulas, you’ll see help and example usages for them on the formula edit screen. There’s some info in the online user manual too.
.
