% Achieved

[Lawal]

Please I need assistance resolving this.

Actual Target % Achieved should be
-150 -100 -150/100

what is the formulae to achieve this

I was trying to use the formular below for different scenario

=IF(B3<C3,B3/C3,IF(B3>C3,(B3/C3),IF(-B3>-(C3),(-B3/C3),IF((C3>B3<0),(-B3/ABS(C3)),B3/C3))))

 

[Pete_UK]

I think you probably want something like this:

=IF(ABS(B2)>ABS(C2),B2/ABS(C2),B2/C2)

but if this doesn't give you the results that you want then post back
with a few more examples.

Hope this helps.

Pete

 

[Ms-Exl-Learner]

Assume that you are having data like this.

A1 Cell
-150

B1 Cell
-100

In C1 Cell paste the below formula
=A1/B1

Now place the cursor in C1 cell and Do right Click>>Format
Cells>>Number>>Category>>Click “Percentage†(If required change the decimal
places to 0) and give ok.

Remember to Click Yes, if this post helps!