formula

V

Val

Hello,

I have a formula in the cell. I want to be able to enter a number in the
cell if necessary.

In the event the number is "0" or erased, I would like the formula to remain.

Thanks
 
N

Niek Otten

Not possible without programming. Not a good idea either. Use another cell
instead.

=IF(A1=0,OriginalFormula,A1)
 
P

PeterAtherton

Val

You can not enter a number over a formula and have it remain in the cell.

The secret is to enter a formula that will give you the answer you want. Say
that you wanted to show a sum that was over 50 but show a blank cell if the
answer is below 50 then =if(sum(A1:G1)>50,sum(a1:g1),"")

To show a zero if(sum(A1:G1)>50,sum(a1:g1),0)

Hope this helps.

Peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Newbie Help - IF Yes No Function 0
Autonumber field in Excel that behaves the same as Access 0
Copy addition formula of non-consecutive horizontal cells 2
Excel does not accept text format! 0
Excel - Wich Function should I use? 1
Delete all data after a symbol in a field 0
Delete a formula but leave the data. 2
Use TODAY() function as the criteria in a SUMIF formula 1

Top