Formula to display negative numbers as positive

ghard1

Active Member
Joined
May 4, 2005
Messages
331
Hi,

I am using the following formula to subtract two numbers (if there are numbers in each corresponding number and row):

=IF(AP2>0,AP2-AO2,"")

Every once in a while, the formula result is negative which causes an error. Can anyone think of a way to modify the above formula to convert any negative results to positive ones?

Thanks
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Watch MrExcel Video

Forum statistics

Threads
1,113,859
Messages
5,544,700
Members
410,630
Latest member
Maggie28
Top