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

Options
edited 12/09/19

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

Tags:

• ✭✭✭✭✭✭
Options

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

• Options

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.