Forum Discussion

KCarol's avatar
KCarol
Copper Contributor
Jan 20, 2024

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

Resources