| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF function won't post cell value
Trying to get this to work:
IF cell C4=0 then post cell F4 value IF cells C4 and F4 are both 0 then post cell I4's value. =IF(C4=0,F4, IF(C4=0,F4=0,I4)) If C4 is 0 and F4 has a value it will post F4's value but if both C4 and F4 are 0 all it will post in I4 is 0 not I4's value. -- Loren |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF function won't post cell value
See if this does the trick for you:
=IF(AND(C4=0,F40),F4,IF(AND(C4=0,F4=0),I4,0)) -- Kevin Backmann "Loren" wrote: Trying to get this to work: IF cell C4=0 then post cell F4 value IF cells C4 and F4 are both 0 then post cell I4's value. =IF(C4=0,F4, IF(C4=0,F4=0,I4)) If C4 is 0 and F4 has a value it will post F4's value but if both C4 and F4 are 0 all it will post in I4 is 0 not I4's value. -- Loren |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF function won't post cell value
Try: =IF(C4=0,F4,IF(AND(C4=0,F4=0,I4)))
"IF C4= 0, THEN F4, ELSE IF C4 = 0 AND F4 = 0, THEN I4" Dave -- Brevity is the soul of wit. "Loren" wrote: Trying to get this to work: IF cell C4=0 then post cell F4 value IF cells C4 and F4 are both 0 then post cell I4's value. =IF(C4=0,F4, IF(C4=0,F4=0,I4)) If C4 is 0 and F4 has a value it will post F4's value but if both C4 and F4 are 0 all it will post in I4 is 0 not I4's value. -- Loren |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Concatinate a filename | Excel Discussion (Misc queries) | |||
| Function syntax to compare cell contents | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
