Need help with IF Formula

[iteriwarren]

I want: IF Sum A is > Sum B then return B/A-1 but if Sum B > Sum A then then return A/B-1. I do not know what formula to put in.

[Pete_UK]

Does Sum A mean sum of a range of cells, and Sum B is for a different range?

Pete

[iteriwarren]

Yes that is correct.

[Jonmo1]

Also, is that

(B/A)-1
or
B/(A-1)

There's a big difference.

[noufalwn]

=if(A>B,B/(A-1),A/(B-1)

[iteriwarren]

(B/A)-1 is correct.

[Jonmo1]

Try

=MIN(A/B,B/A)-1

[iteriwarren]

This worked: =if(A>B,B/(A-1),A/(B-1) Thanks!

[Pete_UK]

That contradicts what you said in post #6, and you should have another bracket at the end.

Pete

[iteriwarren]

My apologies.