=if(and(a2>0,a2<21),200,if
=IF(AND(A1>0,A1<21),200,IF(A1>20,ROUNDUP(A1/10,0)*100,0))
If you are experiencing a similar issue, please ask a related question
Title | # Comments | Views | Activity |
---|---|---|---|
Excel 2016 - Black cell borders | 11 | 26 | |
Excel Automation VBA | 19 | 25 | |
Help with Excel formula | 6 | 34 | |
Subtotal clarification and between two sheets comparison | 9 | 8 |
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
16 Experts available now in Live!