Forum Discussion
If and Max formula?
Hi
In the attaced document I have done a example for my issue.
I need some friendly help to solve the problem I explain in the document.
I have tried to use this formula, but it will not work as I want it. So this is not the one to be used:
=IF(C4>=B4;(C4-B4)*$B$1;"- USD")
Please see attached document for the issue I have.
Looking forward to any help.
Thank you.
Hi Roger,
Perhaps
=(C4-MAX($B$4:B$4))*$B$1*((C4-MAX($B$4:B$4)>0))
in C7 and drag it to the right. Attached.
- Wow - You are amazing! It´s working fine. Excellent. Huge thank you! You made my day. Thank you!
