New
#11
If you are going to insist on using negative logic the correct formula is..
if($A1<>"",do calculations,"")
This is copied into each cell where you want to do calculations.
Using the $ in front of the A mans that column A will be used as the test value for all formulas.
Tanya