ExcelBanter - question about ABS Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - question about ABS Function (https://www.excelbanter.com/excel-worksheet-functions/160183-question-about-abs-function.html)

terry

question about ABS Function

=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.

--
thanks

kassie

question about ABS Function

=IF(OR(F7="",F8=""),"",ABS(F7-F8))

--
Hth

Kassie Kasselman
Change xxx to hotmail

"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.

--
thanks

Gord Dibben

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.

All times are GMT +1. The time now is 06:17 AM.