Excel Formula

[cdl769]

Hello all,

I was wondering what the formula would be for this scenario with 4 conditions.

If Cell B is Greater/Equal to Cell C than Cell B is minus Cell A

OR

If Cell C is Greater/Equal to Cell B than Cell C is minus Cell A

OR

IF Cell B is Lower/Blank than Cell A leave Blank

OR

IF Cell C is Lower/Blank than Cell A leave Blank

If you’re able to help, very much appreciated

 

[earthworm]

=IF(B1>=C1,B1-A1,IF(C1>=B1,C1-A1,IF(OR(B1<A1,B1="")),IF(OR(C1<A1,C1="")),"",""))

 

[cdl769]

Thank you.

I copied the formula directly and it come back with: “There’s a problem with this formula”

I clicked OK then it showed this: