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
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 

 #UNPARSEABLE

 

 

=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.  

Tags:
· Share on FacebookShare on Twitter

Comments

  • 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.

    · Share on FacebookShare on Twitter
  • Hugh Robinson
    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))))

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories