View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Nozza Nozza is offline
external usenet poster
 
Posts: 11
Default "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)