Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need to make cell blank if no data in previous cell
I have a data in columns, I want data to be shown only if there is
data in that row if no data then leave it blank (here is what I am asking for) Stock trade Gain/Loss Gain/Loss for all trades xxxx xxxx xxxxx abc 4.18% 4.18% def 3.77% 7.95% [no trade] N/A 7.95% [no trade] N/A 7.95% i want trade column to appear blaink in cell of gain/loss for all trade instead of showing 7.95%. If there is no data but the formula is in column, third line shows 7.95%, 4th line shows 7.95%, 5th line 7.95% and this is keep going as there is formula there. I want to to make if there is no data in GAIN/ LOSS column then GAIN/LOSS FOR ALL TRADES to appear blank. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
need to make cell blank if no data in previous cell
Use the IsBlank() worksheet function in your formula.
(This does not require VBA programming, so these types of questions could/should be posted in the Worksheet.Functions newsgroup.) For example, if cell A2 is blank, then cell B2 would have the formula: =IF(ISBLANK(A2),"",YourFormulaHere) or =IF(ISBLANK(A2),0,YourFormulaHere), with column $B formatted not to show values if they are 0. -- Regards, Bill Renaud |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to make cell blank if no data in that row | New Users to Excel | |||
Need macro to check if cell is not blank & previous cell is blank, copy information from row above & paste | Excel Programming | |||
Cell Blank if duplicate value in previous cell | Excel Programming | |||
Searching for blank cell and populating based on previous data | Excel Programming | |||
How would I fill blank cells with the data from a previous cell? | Excel Discussion (Misc queries) |