Thread
:
cell formular
View Single Post
#
3
Posted to microsoft.public.excel.misc
paul
external usenet poster
Posts: 247
cell formular
not without a macro.As an alternative you can have a "manual input cell"
somewhere else,say a25,and in a 24 have =if(A25="",vlookup(c15,d25:e25,2),a25)
..
--
paul
remove nospam for email addy!
"Glenn" wrote:
I have setup a formular for a cell A24. This cell have the formular of
vlookup(c15,d25:e25,2). This returns the correct results in A24. My problem
is this:
I woulld like to be able to change the results in A24. Let say the resulet
in A24 is $500.00. I change A24 to $775. When I do this I loose the
originial vllok formulatr in A24. I have protected the sheet but then it
will not let me change the results in A24. Is there anyway to lock the
formular but change the results of A24 manually?
Reply With Quote
paul
View Public Profile
Find all posts by paul