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)
HansVogelaar If V19 = 5,000.00 and V29 = 4,200.00 and V28 = 3,650.00. C28 = 10,000.00
which calculation will be the answer? 4,200.00 or 3,3650.00? I am just making sure this is correct, which I have my concerns. It's been awhile since I worked with calculations in excel.
THANK YOU SO MUCH.
Barbara
Can you explain more clearly what the formula should do?