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 abo...
excel
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Jan 20, 2024

KCarol 

Use

 

=IF(W8>100000000, 1.8%, IF(W8>20000000, 2%, 2.5%)

  • KCarol's avatar
    KCarol
    Copper Contributor
    Jan 20, 2024
    Wow, it worked. You're a life saver. Thank you so much. ā¤ļø

Resources