Headhoncho67
New member
- Joined
- Jun 26, 2014
- Messages
- 4
- Reaction score
- 0
- Points
- 0
Hi there,
I would like to ide the #value in a cell.
I have formula to calculate the variation of 2 cells as a percentage - but when referencing an empty cell waiting for data, I get the #value.
Current formula is:
=(AE127-AD127)/ABS(AE127)*100
(Thee may also be better way to achieve this to)
I'd really appreciate any help -cant stand errors showing up - maybe a bit of OCD?
I would like to ide the #value in a cell.
I have formula to calculate the variation of 2 cells as a percentage - but when referencing an empty cell waiting for data, I get the #value.
Current formula is:
=(AE127-AD127)/ABS(AE127)*100
(Thee may also be better way to achieve this to)
I'd really appreciate any help -cant stand errors showing up - maybe a bit of OCD?