how to apply formula in excel cell without the value being shown
southpark
The question may be a little difficult to comprehend and i cannot find better way to out it across. So here i am explaining with an image 
I have a formula in G8. I want to apply the formula to 500 rows.
But when i drag.. i get this 
What I want is that the formula should be present for all the 500 rows.. but zero should not be visible initially. That is, after I enter value in G9, value should be calculated in G9
I know that we can hide the zeros from the option of excel..but that does not serve my purpose. Is there any way to achieve what i need?
Iqbal
Type this in your result cells.
=IF(A11+B11 = 0, "", A11+B11)
Here A11+B11 is my formula to get the summation of A11 and B11.
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: Streaming Data.Vector to File using io-streams
- Next: Mixing raw html with template inheritance in django
Related
Related Related
- 1
How to change a formula according to cell value in excel?
- 2
Excel apply formula to existing cells value without copy/paste
- 3
Excel apply complicated formula to existing cells value without copy/paste
- 4
Apply new cell value in Excel without pressing Enter or moving focus
- 5
How do I apply a formula to a range without applying said formula to every cell?
- 6
Excel - Replace cell link in formula with value in cell
- 7
Excel - How to read cell value exactly as they show up on the spreadsheet, not by formula
- 8
How to pass int value from cell in to excel formula
- 9
Expanding an Excel formula without referencing the previous cell
- 10
How to apply formula to cells with value
- 11
How to apply a formula to each cell of a numpy array
- 12
Excel Formula Assign Value based on Color of Cell
- 13
Excel - Inserting cell value in formula column name
- 14
Excel 2007 Cut and paste formula or value without changing cell formatting - paste options greyed out
- 15
In Excel, if cell is blank OR formula result is 0, then how to show blank cell instead of #VALUE! error?
- 16
Excel IF cell reference formula being changed when recorded in VBA
- 17
Formula if cell = value to carry out formula else...Excel VBA
- 18
Can you apply a formula to a formula in Excel instead of the value?
- 19
Apply Formula Cell to a DataGridview
- 20
Excel 2016 don't apply formula if cell is blank
- 21
How do I create a formula in excel that searches for a value in row, and then takes the value from another cell in that column?
- 22
How to color a cell in Excel using a formula?
- 23
excel: how to *clone* the formula to another cell?
- 24
How to put a formula into a cell by Excel VBA?
- 25
How to use a cell in Excel that has a formula as a condition?
- 26
String type value added to Excel cell, but it shown like double
- 27
Excel Formula - Count Value without repetition
- 28
MS Excel, How to make the IF formula spit back the value of the cell if condition is FALSE?
- 29
How can I write an excel formula to return a value from a range based on the contents of a cell?
Comments