View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default "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)