Help me reverse my formula please?

[Jyggalag]

Hi all,

Thanks to some of your great earlier contributions I was able to set up with this formula:

=IFERROR(LET(mpos;MATCH(1E+100;G7:K7);
mval;INDEX(G7:K7;mpos);
IF(mval>V7;
RIGHT(INDEX($G$3:$K$3;mpos);2) & " TPC is bigger than TPC MEC by " & TEXT(ROUND(mval-V7;0);"#.##0") & " USD";
""));"")

The formula takes my value under column V and subtracts it from the latest column inbetween column F-K. If column F-K is larger, the formula returns the amount it is larger by (540 USD in above example).

I would like to change this formula, so it does the opposite, meaning that it will subtract my value in F-K from my value in V, and inform me if the value in column V is larger and by how much?

I tried myself but it wasnt as simple as I thought! Would greatly appreciate some help

 

[RobP]

My attempt would give you :

=IFERROR(LET(mpos;MATCH(1E+100;G7:K7);mval;INDEX(G7:K7;mpos);IF(mval<V7;"TPC MEC is bigger than TPC " &  RIGHT(INDEX($G$3:$K$3;mpos);2)& " by " & TEXT(ROUND(V7-mval;0);"#.##0") & " USD";""));"")

Forgive me, as I had to change all the ";" to "," in your formula for my version of Excel. I think I changed them all back, but highlighting just in case you find one I missed..

Rgds
Rob