If And Formula Help

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.

Find more posts tagged with

Formulas

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

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