Forum Discussion
KCarol
Jan 20, 2024Copper Contributor
FALSE ERROR
Hello,
Can someone help me with this? I keep on getting FALSE with below formula. š Thank you in advance!
2.5% - 0-20,000,000.00
2.0% - 20,000,001 to 100,000,000
1.8% - 100,000,001 and above
=IF(AND(W8>0,W8<=20000000,AND(W8>=20000001,W8<=100000000,AND(W8>=100000001),"2.5%"),"2.0%"),"1.8%")
2 Replies
- KCarolCopper ContributorWow, it worked. You're a life saver. Thank you so much. ā¤ļø