Forum Discussion
Solved
Help with If, then formulas
If column a contains a date, then equal 100%, if not, then 0%, for a sheet that contains 30,000 lines. I keep getting a SPILL error
This formula will attempt to return 9 values to 9 cells: one for each cell in I2:I10.
One option is to use
=IF(I2>0, 100, 0)
or a bit shorter
=100*(I2>0)
Then fill down.
Or do you want to return 100 if ALL cells in I2:I10 are positive?
=IF(I2:I10>0, 100,0)
This formula will attempt to return 9 values to 9 cells: one for each cell in I2:I10.
One option is to use
=IF(I2>0, 100, 0)
or a bit shorter
=100*(I2>0)
Then fill down.
Or do you want to return 100 if ALL cells in I2:I10 are positive?
- That worked, thank you!