Thread: Help!
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carim Carim is offline
external usenet poster
 
Posts: 510
Default Help!

Hi,

If your cells are as follows :
cell A1 = 513
cell B1 = 515
cell B2 = 657
cell B3 = 234
Then in cell C1 you can type :
=IF(B1$A$1,B1,$A$1)
and copy formula in cells C2 and C3

HTH
Cheers
Carim