View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Neil Neil is offline
external usenet poster
 
Posts: 173
Default showing a cell when it is not blank and ignoring it if it is

Hi

I would like A3 in my spreadsheet to show the value of A2 if the value of A1
is greater than 50.

So

A1 =67 A2= 340 A3= 340
or

A1=0 A2=340 A3=0

Sometimes A1 and A2 will be blank so i would like A3 to return blank and not
as False as i get so far on my own efforts!

Many Thanks