Is there any way in Excel to get a formula to covert to a value after the
first time it calculates? I have a column that calcuates whether or not a
budget has been overspent after each bill is paid against it:
=if(b22<0,"YES","NO"). For the sake of historical data it would be very
helpful for me to keep a running record of the total remainder one each bill
line. Instead, as soon as one bill overspends the budget, the entire column
changes to "NO." Any suggestions on a way to make cells hold their initially
calculated value and/or a better way to design this? Thanks.

Click in the formula bar, hit F9, then enter. You could also Copy, click
Edit/PasteSpecial/Values then ESC to exit copy mode.


"spence" wrote:

Is there any way in Excel to get a formula to covert to a value after the
first time it calculates? I have a column that calcuates whether or not a
budget has been overspent after each bill is paid against it:
=if(b22<0,"YES","NO"). For the sake of historical data it would be very
helpful for me to keep a running record of the total remainder one each bill
line. Instead, as soon as one bill overspends the budget, the entire column
changes to "NO." Any suggestions on a way to make cells hold their initially
calculated value and/or a better way to design this? Thanks.

thanks for your response, but i'm looking for a way to hold the values "on
the fly" without having to go back in and edit them, the reason being that
i'm dealing with five hundred copies of the spreadsheet based on a template
and then, using a third party utility, pulling the data range in question for
all five hund rend sheets into a single sheet. going into each of the five
hundred on a monthly basis after data is entered isn't feasible.

"JMB" wrote:

Click in the formula bar, hit F9, then enter. You could also Copy, click
Edit/PasteSpecial/Values then ESC to exit copy mode.


"spence" wrote:

Is there any way in Excel to get a formula to covert to a value after the
first time it calculates? I have a column that calcuates whether or not a
budget has been overspent after each bill is paid against it:
=if(b22<0,"YES","NO"). For the sake of historical data it would be very
helpful for me to keep a running record of the total remainder one each bill
line. Instead, as soon as one bill overspends the budget, the entire column
changes to "NO." Any suggestions on a way to make cells hold their initially
calculated value and/or a better way to design this? Thanks.