| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"IF" "THEN" Help needed
I need to see a simple "IF" "THEN" that will retreave a sum of a cell like
this. in "C7" I need this to happpen If "C4" is = to 20 THEN show cell "I62" (showing blank or the contents of cell I62) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"IF" "THEN" Help needed
It may be helpful to look in the help index for
IF -- Don Guillett Microsoft MVP Excel SalesAid Software "j5b9721" wrote in message ... I need to see a simple "IF" "THEN" that will retreave a sum of a cell like this. in "C7" I need this to happpen If "C4" is = to 20 THEN show cell "I62" (showing blank or the contents of cell I62) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"IF" "THEN" Help needed
Try typing IF into Excel help, and work from there. It will tell you the
syntax and give you examples. You can also get help on Excel functions through the fx button alongside the formula bar. -- David Biddulph "j5b9721" wrote in message ... I need to see a simple "IF" "THEN" that will retreave a sum of a cell like this. in "C7" I need this to happpen If "C4" is = to 20 THEN show cell "I62" (showing blank or the contents of cell I62) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"IF" "THEN" Help needed
=IF(C4=20,I62,"") entered in C7
Gord Dibben MS Excel MVP On Sat, 15 Sep 2007 09:16:00 -0700, j5b9721 wrote: I need to see a simple "IF" "THEN" that will retreave a sum of a cell like this. in "C7" I need this to happpen If "C4" is = to 20 THEN show cell "I62" (showing blank or the contents of cell I62) |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"IF" "THEN" Help needed
On Sat, 15 Sep 2007 09:16:00 -0700, j5b9721
wrote: I need to see a simple "IF" "THEN" that will retreave a sum of a cell like this. in "C7" I need this to happpen If "C4" is = to 20 THEN show cell "I62" (showing blank or the contents of cell I62) You could try something like =IF(C4=20,I62,"") HTH Noz -- Email (ROT13) |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"IF" "THEN" Help needed
One mo
=IF(C4<20,"",IF(I62="","",I62)) j5b9721 wrote: I need to see a simple "IF" "THEN" that will retreave a sum of a cell like this. in "C7" I need this to happpen If "C4" is = to 20 THEN show cell "I62" (showing blank or the contents of cell I62) -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Linear Mode
