Forum Discussion
Error with IF formula (testing 3 variables and entering the specified value. if one is true.)
Hi Ed, thanks for your help! I tried what you suggested, however the conversion for $10000 sales is not showing 75. Here is the formula I have entered: =IFS(F3>=12500,100,F3>=10000,75,F3>=7500,50,F3<7500,0)
Do you happen to see why that would not be correctly evaluated?
Madeline Clancy wrote:Hi Ed, thanks for your help! I tried what you suggested, however the conversion for $10000 sales is not showing 75. Here is the formula I have entered: =IFS(F3>=12500,100,F3>=10000,75,F3>=7500,50,F3<7500,0)
Do you happen to see why that would not be correctly evaluated?
No. It should work. When I type in 10,000 it works fine, correctly returning $75. Are you typing in 10,000 or is it a formula? It could be one of those things where the formula is returning 9,999.9999999997 or something due to how excel calculates. You may need to wrap your sales formula in a ROUND(n,2) function, or wrap F3 above in round(F3,2) in each instance.
If only $10000 is not the text...
