devangjmehta
New Member
- Joined
- Apr 27, 2011
- Messages
- 8
Dear Sir,
I am making a budget format where in I have a cell which calculates over or under budget percentage.
If I put in '0' as the budgeted figure the percentage cell shows an error, but if I put in '1' as budgeted figure it doesn't show any error. But I don't want to put '1' as the budgeted figure because it will start adding up in the total cell at the bottom.
Example of a formula I am using: '=100*F8/B8' where F8 is variance and B8 is budgeted amount.
Please help.
Thanking you,
With warm regards,
Devang
I am making a budget format where in I have a cell which calculates over or under budget percentage.
If I put in '0' as the budgeted figure the percentage cell shows an error, but if I put in '1' as budgeted figure it doesn't show any error. But I don't want to put '1' as the budgeted figure because it will start adding up in the total cell at the bottom.
Example of a formula I am using: '=100*F8/B8' where F8 is variance and B8 is budgeted amount.
Please help.
Thanking you,
With warm regards,
Devang