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 a...
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.