question about ABS Function
Trap for Fx not having a value
=IF(F4="","",ABS(F3-F4))
Or maybe trap for both cells
=IF(OR(F3="",(F4="")),"",ABS(F3-F4))
Gord Dibben MS Excel MVP
On Sat, 29 Sep 2007 07:16:01 -0700, Terry
wrote:
=ABS(F3-F4)
F G =ABS(F4-F5)
4 100 100
5 110 10 =ABS(F5-F6)
6 120 10 =ABS(F6-F7)
7 125 5 =ABS(F7-F8)
8 125
How do i keep the answer from showing up in "G" when the number in "F8" has
not been entered yet.
|