| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Function Question?? | Excel Discussion (Misc queries) | |||
| Function question | Excel Worksheet Functions | |||
| Function Question | Excel Worksheet Functions | |||
| NOW function question | Excel Worksheet Functions | |||
| Function question | Excel Worksheet Functions | |||
Linear Mode
