Forum Discussion

JeffPeterson's avatar
JeffPeterson
Qrew Trainee
8 years ago

I need help with mathematical formulas

I am super new to QB so please bare with me...  I created a table of sales reps and on that table has a gross amount listed.  I need to create a formula for this gross amount to be a certain percentag...
Ask about Quickbase functionality
JeffPeterson's avatar
JeffPeterson
Qrew Trainee
8 years ago
Hi Nick, for example, something as easy as this: =SUM(G18*H18)  In this case, G18 is a dollar amount, H18 is a percentage, and I18 is the answer to the equation.

I'm super new at QB and just don't know where I can even write formulas in the system.
  • GauravSharma3's avatar
    GauravSharma3
    Qrew Commander
    8 years ago
    Hi Jeff,

    Did you mean =SUM(G18:H18)? Can you please post some figures and the expected output?

    Thanks,
    Gaurav