Formula producing a negative value

[Pheonix2332]

Afternoon all,

I'm in the process of making a calculator for my work place an have run into a slight mind block I'm trying to calculate differences on 2 variables which is based on a pass or fail scenario the code I'm using is this "=IF(R3="Fail",IF(AND(G3="",N3=""),ROUND((H3-O3),3),ROUND((G3-N3),3))& " KG","N/A")" however its producing a negative value and needs to have the negative value removed to a positive - i know its caused buy the figures being rounded up under the last if function "ROUND((G3-N3),3)" but need it to be a positive result. I've tried the absolute function but getting conflicting error message on excel anybody able to help please ?

 

[Fluff]

How about

=IF(R3="Fail",IF(AND(G3="",N3=""),ABS(ROUND((H3-O3),3)),ABS(ROUND((G3-N3),3)))& " KG","N/A")

 

[Pheonix2332]

How about

=IF(R3="Fail",IF(AND(G3="",N3=""),ABS(ROUND((H3-O3),3)),ABS(ROUND((G3-N3),3)))& " KG","N/A")

this has worked thanks for the help

 

[Fluff]

You're welcome & thanks for the feedback.