Ex: =IF(B11>B16,SUM(B11-B16)*B10,IF(B11<B16,SUM(B11-B16)*B10,IF(B11=B16,"$0.00")))

This is the formula I'm using in cell B17 to calculate the resultant variance between cells B11 and B16 * B10. No problem here it works. What I want to occur is to modify this formula in it's current cell to also print "text" in cell B18.

I do not want to write a formula in B18, but to make the above formula in B17 perform this action from it's current cell simultaneously.

Test this formula as it is, by copying this formula to cell 'B17', then enter: 5 in cell 'B10', enter: $50.00 in cell 'B11', then enter: either $50.00/$55.00/$45.00 in cell 'B16'.

Now, what I want is to insert a function in this formula that automatically prints: "equal"/"high"/"low" in cell 'B18'. How would I code this?

Not sure if it can be done, any advice appreciated!