ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,932
- Office Version
- 2007
- Platform
- Windows
I use the simple formula below but sometimes the cell in question doesnt yet have a value.
Because of this the cell that the formula is in shows #VALUE
Please advise how it is written so the cell shows £0.00
The formula in use is as follows.
Because of this the cell that the formula is in shows #VALUE
Please advise how it is written so the cell shows £0.00
The formula in use is as follows.
VBA Code:
=SUM(J2-N2)