Combining if statements

[SANJ]

Hi All,
Please help with this:
i am trying to combine if statements to give me if sales is 102% above target it returns "Above target". if sales if between 98% to 102 % it returns "Achieved" and if sales is less than 98% than it returns "below target"

can someone please help

[teylyn]

Hello SANJ,

welcome to the forum.

With an IF, it would look something like

=if(A1<0.98,"Below target",if(A1<1.02,"Achieved","Above target"))

Alternatively, you could use

=LOOKUP(A1,{0,0.98,1.02},{"below","achieved","above"})

[Rebuild8]

if target is in cell A4 and sales are in A5, then use this formula:
=IF(A5/A4<0.98,"below target",IF(A5/A4>1.02,"Above target","Achieved"))

[SANJ]

wow. thank you so much sir