Forum Discussion
lhunter700
May 03, 2022Copper Contributor
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...
- May 03, 2022
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,"") )
lhunter700
May 03, 2022Copper Contributor
Thank-you! That worked and is exactly what I needed it to do!!!
SergeiBaklan
May 03, 2022Diamond Contributor
lhunter700 , you are welcome