Dec 30 2020 04:42 PM - edited Jan 01 2021 09:02 PM
Dec 30 2020 04:50 PM
Seems like a simple IF statement will do the trick. I'm a bit confused by how the yellow cells are connected but this would be how the IF statement will work:
=IF(C27>-9000, X, Y)
X is the TRUE scenario and that's where you can input a default value if negative value is too high.
Y is the FALSE scenario and can replaced by the regular function that would be used
Dec 30 2020 05:28 PM
Thank you for you quick response. I have little expertise with Excel formulas, so here's what the highlighted cells show:
I tried using your IF Statement, however, the balance still increased.
Dec 30 2020 05:52 PM
Still a bit confused. If I understand correctly, the two differences between E45 and L45 is:
1. the exclusion of the -100 (J20 that is referenced in K27); and
2. K20 being 4.91 instead of 104.91
Before setting up the IF function. what is the rule you are trying to establish? Is the figure supposed to be split or reduced by a certain amount? Is the 104.91 a static figure or something that is generated through a calculation?