decimal places

[stuartford]

im using an IF formula to work out current stock possitions
=IF(AD5="",AD4+AE4-AF4,AD5+AE4-AF4)

but its giving me the value and up to as many as 10 decimal places and i cant make it 2 places via the usual methods of formating

is there any formula that i can add to format this?

Cheers stuart

 

[fairwinds]

Hi,
Try:

=ROUND(IF(AD5="",AD4+AE4-AF4,AD5+AE4-AF4),2)

 

[stuartford]

it works for that formula but not this one

=IF(AG4>AE4,"OOC "&AG4-AE4,"")

cheers for ya help

stu

 

[fairwinds]

=IF(AG4>AE4,"OOC "&ROUND(AG4-AE4,2),"")

 

[stuartford]

cheers fella thats sorted it

stu