=IF(I2<7,1,IF(I2="", 0))
The question becomes: What happens if I2 is equal to or greater than 7?
=IF(I2<7,1,IF(I2="", 0))
=IF(I2="",0,IF(I2<7, 1))
IF(OR(I2="", I2>=7), 0, 1)
=IF(I1<7,1,0)
=IF(I1<7,1,IF(I1="",0,2))
Title | # Comments | Views | Activity |
---|---|---|---|
excel vba write value to the referenced cell formula location | 7 | 20 | |
Excel- VBA help on macros that size columns and rows | 7 | 21 | |
Excel Spreadsheet in a Word 2016 document. | 3 | 30 | |
From where do I download MySQL for Excel? | 2 | 9 |
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
14 Experts available now in Live!