If stmnt

[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

 

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