Calculating Variances

Dronski

New Member
Joined
Dec 7, 2005
Messages
2
I have a formula of which one or both of the reference cells will sometimes result in a $0.00 value, ex, (AF2-AH2)/ABS(AH2).

In which case If AH2 is 0.00 then I want the result to be the absolute of AF2 .

If AF2 is 0.00 then it will be a result of the absoute of AH2 in a negative value.

Can anyone help me with this? :rolleyes:
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
Try:

=IF(AH2=0,ABS(AF2),IF(AF2=0,-ABS(AH2),(AF2-AH2)/ABS(AH2)))

Denis
 

Watch MrExcel Video

Forum statistics

Threads
1,118,530
Messages
5,572,675
Members
412,481
Latest member
nhantam
Top