Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
29
Views
Topic starter
Hello,
I need a formula for cell B1 if cell A1 contain value 1 to 499 then B1 should return value 13% at the same time if A1 contain value more than 500 then B1 return value 15%.
Posted : 05/06/2022 5:04 am
Hi Waqas,
Try this in B1:
=IF(A1>500,15%,IF(A1>=1,13%,0))
Posted : 07/06/2022 12:57 am
Topic starter
Hi Catalin Bombea
Thanks for your reply and your given formula is useful for my sheet.
Posted : 12/06/2022 8:13 am
