### Multiple IF statements

Posted:

**Thu Nov 21, 2019 2:06 pm**Have spent considerable time just trying to work out how to enter a 'simple' function which is to return a varying value as follows :-

Sorry unable to paste or create a table here.

Is there any way to integrate the three functions into one formula - any advice would be most appreciated

Sorry unable to paste or create a table here.

• A B C

1 F A Desired Value

2 2 1 3 Where column A is greater than column B

3 1 1 1 Where column A is equal to column B

4 1 2 0 Where column A is less than column B

Is there any way to integrate the three functions into one formula - any advice would be most appreciated