Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
12
Views
Topic starter
Hello,
I need a formula for cell B1 if cell A1 contains value 1 to 300 and 700 to 1099 then B1 should return value 15% at the same time if A1 contains value more than 301 to 699 and 1100 to above then B1 return value 13%.
Posted : 09/04/2023 4:20 am
Hello,
A short answer is following formula:
=IF(OR(A1<301,AND(A1>=700,A1<1100)),15%,13%)
But this is not dynamic in any way. If the conditions never change, then this is fine.
Br,
Anders
Posted : 09/04/2023 9:09 am
Topic starter
Hello
No. Condition will never change. thanks for your help.
Posted : 11/04/2023 7:13 am
