Calculate Access Conditional formula

K

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
 
S

Stefan Hoffmann

hi Ken,
Can someone help me change this excel formula to Access formula for
progressive tax withheld.
Click to expand...
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)))
Click to expand...
Replace IF with IIf and B2 with the name of your control or field.

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


mfG
--> stefan <--
 
D

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

hor vannara

Ken said:
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
Click to expand...
 
Top