Blank Cells with Formulas

K

Kurt

I have a spreadsheet which I have formulas. I have formula
in blank columns waiting for me to input data that are
based off other formula. Until then it copies the value
of the last formula in the columns waiting for data.
 
G

Gord Dibben

Kurt

One method to take care of this is to enter an IF clause in your formulas.

=IF(cellvalue="","",cell*othercell)

Which equates to "if a cell is empty(or no value), show as blank, otherwise
show the formula result"

If you have trouble, post your formula and get more specific answers.

Gord Dibben Excel MVP
 
P

Peter Atherton

Kurt

I presume that you are after a culmulative total. If the
total is in column D then in D3

If(A3="","",C3+D2)

Regards
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

Copy addition formula of non-consecutive horizontal cells 2
Cell data entering slow! 0
Autonumber field in Excel that behaves the same as Access 0
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Hide columns based on row values 2
Consolidation Table from Different Excel Tabs with Different Format 1
Newbie Help - IF Yes No Function 0
Display weeks from a Milestone 0

Top