Forum Discussion
Bhall505
Feb 13, 2023Copper Contributor
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...
Bhall505
Mar 06, 2023Copper Contributor
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
HansVogelaar
Mar 06, 2023MVP
Can you explain more clearly what the formula should do?