ABS and If producing !VALUE!

Hi Guys

I know this is a schoolboy error but I can't find the solution. I get the correct answer and the incorrect one in the next row. No hair left
Hope someone has a moment.

=ABS(IF(P4="sales","-",T4)) returns 208.33
=ABS(IF(P5="sales","-",T5)) Returns #Value!

Mark

The formula in X2 is this:

=IF(P2="sales",U2," - ")

but in X3 you have this:

=ABS(IF(P3<>"sales",U3," - "))

So, you are trying to get the ABSolute value of a string - as that has no numerical value it returns the #VALUE error to X3.

It might be better to change the formula in X2 to this:

=IF(P2="sales",U2,0)

then format the cell as Accounting so that the zero is displayed as a hyphen, and then copy that formula down.

Hope this helps.

Pete

Hi guys thought i had thanked you but can't see reply. Any how thanks I am now formatting my work in accountancy. Thanks
And i have been able to use your example, Vandan for the other issues in the same Spread Sheet.

Thanks again for a great forum.

Mark