Forum Discussion
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?
5 Replies
What is the formula you're trying to use?
It would help if you could attach a copy of the workbook without sensitive info, or make it available via OneDrive or Google Drive.
- =IF(I2:I10>0, 100,0)
- =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?
