If stmnt

A

adn4n

Hi basically i would like to place an if statment in my work so that i
will say, take of 9% of earnings, if the total weekly wage is betwee
£56 and £240 a week. What do i put in the logical test part
 
F

Frank Kabel

Hi
if your wage is in B1 and the earnings in A1 try
=IF(AND(B1>56,B1<240),A1*0.09,"not defined")
 
Top