1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Can I simplify my formula?

I have a formula like this:

IFS(Calculation = Fraction, result1, Calculation = Fraction2, Result2) etc.

My calculation is quite large, and I dont want to store it in a different cell. I was wondering if there was a way to have IFS check the calculation against multiple fractions without having the whole calculation in there every time without storing the calculation in a different cell.

submitted by /u/TharicRS
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article