"IF" "THEN" Help needed

J

j5b9721

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)
 
D

David Biddulph

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

Nozza

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)
Click to expand...

You could try something like

=IF(C4=20,I62,"")

HTH

Noz
 
D

Dave Peterson

One more:

=IF(C4<>20,"",IF(I62="","",I62))

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)
Click to expand...
 
Top