| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
% Achieved
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(B3C3,(B3/C3),IF(-B3-(C3),(-B3/C3),IF((C3B3<0),(-B3/ABS(C3)),B3/C3)))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining a cells value once a target is achieved | Excel Worksheet Functions | |||
| % achieved to a negative goal | Excel Worksheet Functions | |||
| SUMPRODUCT to establish whether turnaround date was achieved | Excel Worksheet Functions | |||
| Specifying the person who has achieved the highest result | Excel Worksheet Functions | |||
| Clickable pie chart - anyone know how this might be achieved? | Charts and Charting in Excel | |||
Threaded Mode
