baljeetgrover
New Member
- Joined
- Apr 2, 2016
- Messages
- 5
I am creating excel file in which i want to calculate my online orders to generate profit report. i am getting #value error. I want "L" cell to remain blank if "J" is blank. I know if cell contains formula then it is not considered as blank. Please tell me how can i solve this issue.
Is there a way to have a cell, which contains a formula, be classed as a blank cell?
Or which formula i should use in Cell "L" to keep it blank until i there is numeric value in cell "J" ?
Is there a way to have a cell, which contains a formula, be classed as a blank cell?
Or which formula i should use in Cell "L" to keep it blank until i there is numeric value in cell "J" ?
![Excel%20Help_zpsyulqmnie.png](/board/proxy.php?image=http%3A%2F%2Fi738.photobucket.com%2Falbums%2Fxx25%2Fbaljeetgrover22%2FExcel%2520Help_zpsyulqmnie.png&hash=831ea8c835ffbcc6a4a3f29ba4a8de02)