Forum Discussion
fix an error #VALUE1 in formula with absolute referencing
i m trying to use a formula containing absolute referencing but i keep getting error message #VALUE!.
1 Reply
- Hi! You need to change your O/T 2 Hours from dashes to zeros, excel is reading that as text and can't do math as text. If you change that you'll be good to go!
