Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

If And Formula Help

Hugh Robinson
edited 12/09/19 in Archived 2015 Posts

Hi I am a new user of smartsheet.  I need help on why this excel formual will not work.  I get 




=IF(([Total Billed]40)<10000,0,

IF(AND(([Total Billed]40)>=10000,([Total Billed]40)<20000),([GP Amount]40*5%,

IF(AND(([Total Billed]40)>=20000,([Total Billed]40)<30000),([GP Amount]40*10%,

IF(AND(([Total Billed]40)>=30000),([GP Amount]40*15%,0))))



Thank you in advance for your help.  



  • John Sauber
    John Sauber ✭✭✭✭✭✭

    Instead of a %-sign, use the decimal equivalent. Instead of 5%, use 0.05, for example. Everything else here looks pretty fine to me.

  • Hugh Robinson

    Thank you John.


    Final Formula looks like this:


    =IF(([Total Billed]40)<10000,0,

    IF(AND(([Total Billed]40)>=10000,([Total Billed]40)<20000),[GP Amount]40*0.01,

    IF(AND(([Total Billed]40)>=20000,([Total Billed]40)<30000),[GP Amount]40*0.02,


    IF(AND(([Total Billed]40)>=30000),[GP Amount]40*0.03,0))))

This discussion has been closed.