Formula with if smaller and larger then followed by a calculation

[mathieu11]

Hello

I am looking for a formula which can help met out with the following:

I have 3 columns. X, Y & Z

In X en Y are numbers. Z is the one i want to create a formula for.

Next rules has to be respected.

IF X > Y --> then excel has to calculate 100 - x
IF X< Y --> then excel has to calculate 100 - y

Thanks for you help !
Mathieu

[TMS]

What if x and y are the same?


Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional.)

[mathieu11]

Hello,

Thank you for letting me know, i hope now it's a better title.

In my specific case it is impossible X and Y are the same, but for the correctness you can state outcome may be 0 if they are the same. Thank you for you help !

Kind Regards,
Mathieu

[TMS]

Thanks for fixing the title.

Try

Please Login or Register  to view this content.

Or, if x cannot equal y, then just

Please Login or Register  to view this content.

[mathieu11]

Hello !

Thank you very much, it's what i was looking for !

I have one more thing to ask, is it possible to change the colour of the cell if outcome is produced by X>Y (red) and X<Y (green) ?

[TMS]

You're welcome. Thanks for the rep.

You would use Conditional Formatting for that. Just select all the data, choose Conditional Formatting on the Ribbon, and use the formula:

Please Login or Register  to view this content.

for red

And

Please Login or Register  to view this content.

for green