Forum Discussion
It's been a while since I had to do calculations so this one should be pretty easy.
=IF(C28<V19, V29, V28 is what is on the spread sheet. I have taken over this position and I know it is not complete. C28<V19 should take the value in V28 C28>V29 should take the value i...
The formula is missing a closing parenthesis:
=IF(C28<V19, V29, V28)
But if the formula should return the value of V29 if C28>V19, it should be
=IF(C28<V19, V28, V29)
=IF(C28<V19,V29,V28)
C28 = 8000.00
V19 sales price = 5,000.00
V29 interest = 560.00
V28 interest = 530.00
Is it taking 560.00 or 530.00?
Thank you
You can easily test that yourself by entering the formula in a cell.
With your data, =IF(C28<V19,V29,V28) will return 560.