=(B2-A2)/2+1
same formula if they are both odd. Can one be even and the other odd?
This should work generically for any combination
=CEILING((B2-A2+1)/2,1)
regards, barry
Title | # Comments | Views | Activity |
---|---|---|---|
Excel Formula - If And on Blank Cell | 7 | 26 | |
When a VBA code will not work in Excel 64bit? | 2 | 17 | |
How to Auto-fill data in Database; VBA Code Mixed Combining Two User Forms | 4 | 28 | |
MS Excel "--" in Formula What is it doing? | 3 | 12 |
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
12 Experts available now in Live!