Forum Discussion
Solved
Formula Trouble with Blank Cells
I am trying to do something which seems simple, but having issues... In column B I am trying to enter a value of 5 anytime Column A (the result of which is generated by a formula) has a number gr...
If result in A1 is generated by formula the cell can't be blank. Most probably formula returns empty string or some number.
=IF( A1="", "", IF(A1 >0, 5,"") )
If result in A1 is generated by formula the cell can't be blank. Most probably formula returns empty string or some number.
=IF( A1="", "", IF(A1 >0, 5,"") )- Thank-you! That worked and is exactly what I needed it to do!!!
lhunter700 , you are welcome
