"IF" "THEN" Help needed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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.
 
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
 
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...
 
Back
Top