stuartford
Active Member
- Joined
- Nov 28, 2002
- Messages
- 419
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
=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