IF Formula  Not Working
Why isn't this working? The yellow fields should be returning the numbers in the column "2023 Beginning Balance Char" because they are UNDER 5600 (per my formula). But they are reading the 700 and 798.56 as OVER 5600 and returninng 5600.
=IF([2023 Beginning Balance  Char]12 >= "5,600.00", "$5,600.00", IF([2023 Beginning Balance  Char]12 < "5,600.00", [2023 Beginning Balance  Char]@row)
Best Answer

When using in a formula you just enter the number (no $ sign or quotations).
=IF([2023 Beginning Balance  Char]12 >= 5600, 5600, IF([2023 Beginning Balance  Char]12 < 5600, [2023 Beginning Balance  Char]@row))
Answers

When using in a formula you just enter the number (no $ sign or quotations).
=IF([2023 Beginning Balance  Char]12 >= 5600, 5600, IF([2023 Beginning Balance  Char]12 < 5600, [2023 Beginning Balance  Char]@row))

I did that originally and it made no difference.

I lied. I removed the quotations and that fixed it. Thanks!
Help Article Resources
Categories
Check out the Formula Handbook template!