More Info On Calculations Needed

Viewing 2 reply threads
  • Author
    Posts
  • March 12, 2018 at 9:24 PM #27773

    Kirk Oakes
    Participant

    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!

    March 12, 2018 at 9:48 PM #27774

    Kirk Oakes
    Participant

    I am including an image of what I am striving for…

    Attachments:
    You must be logged in to view attached files.
    March 13, 2018 at 1:40 AM #27782

    Brendan
    Keymaster

    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.

Viewing 2 reply threads

You must be logged in to reply to this topic.