Thread
:
Help!
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Carim
external usenet poster
Posts: 510
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
Reply With Quote
Carim
View Public Profile
Find all posts by Carim