deiaemeth

Forum Replies Created

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter deiaemeth

    (@deiaemeth)

    Sorry, meant something like this ??

    IF(fieldname2<9225,fieldname2*0.1,IF(fieldname2<37450,922.5+(fieldname2-9225)*0.15,IF(fieldname2<90750,5156.25+(fieldname2-37450)*0.25,IF(fieldname2<189300,18481.25+(fieldname2-90750)*0.28,IF(fieldname2<411500,46075.25+(fieldname2-189300)*0.33,IF(fieldname2<413200,19401.25+(fieldname2-411500)*0.35,119996.25+(fieldname2-413200)*0.396))))))

    Thread Starter deiaemeth

    (@deiaemeth)

    I’m trying something along the lines of but doesn’t seem to work…

    =IF(fieldname2<9225,”fieldname*0.1″,IF(fieldname2<37450,”922.5+(37450-9225)*0.15″,IF(fieldname2<90750,”5156.25+(90750-37450)*0.25″,IF(fieldname2<189300,”18481.25+(189300-90750)*0.28″,IF(fieldname2<411500,”46075.25+(411500-189300)*0.33″,IF(fieldname2<413200,”19401.25+(413200-411500)*0.35″,”119996.25+(fieldname2-413200)*0.396″))))))

    Any suggestions would be welcome ??

Viewing 2 replies - 1 through 2 (of 2 total)