View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kassie kassie is offline
external usenet poster
 
Posts: 515
Default 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