Calculate Access Conditional formula

[Ken]

Hi,

Can someone help me change this excel formula to Access formula for
progressive tax withheld.

=IF(B2<=80,0, IF(B2<=250, (B2-80)*0.04, IF(B2<=450, (B2-250)*0.08+6.8,
(B2-450)*0.1+22.8)))

Thanks a lot,
Ken

 

[Stefan Hoffmann]

hi Ken,

Can someone help me change this excel formula to Access formula for
progressive tax withheld.

Where do you want to use it? As a control source?

=IF(B2<=80,0, IF(B2<=250, (B2-80)*0.04, IF(B2<=450, (B2-250)*0.08+6.8,
(B2-450)*0.1+22.8)))

Replace IF with IIf and B2 with the name of your control or field.

"=IIf([field]<=80,..."


mfG
--> stefan <--

 

[Douglas J. Steele]

=Switch(B2<=80, 0, B2<=250, (B2-80)*0.04, B2<=450, (B2-250)*0.08+6.8,
B2>450, (B2-450)*0.1+22.8)

 

[hor vannara]

Hi,

Can someone help me change this excel formula to Access formula for
progressive tax withheld.

=IF(B2<=80,0, IF(B2<=250, (B2-80)*0.04, IF(B2<=450, (B2-250)*0.08+6.8,
(B2-450)*0.1+22.8)))

Thanks a lot,
Ken