Combining Multiple if statements using logical operators

Hello,

I am working on a spreadsheet that compares volume weight to weight and based on the values the formula calculates a cost. Conditions are as follows:

a)if weight is greater than volume weight, then multiply weight by 4.75
b)if weight is greater than volume weight but, less than or equal to 2 then the value is 10
c)if volume weight is greater than weight, then multiply volume weight by 4.75
d)if volume weight is greater than weight but, less than or equal to 2 then the value is 10

Where A2 is weight and F2 is volume weight in the spreadsheet:

IF(A2>F2, A2*4.75, F2*4.75)
IF(A2<=2, 10, A2*4.75)
IF(F2<=2, 10, F2*4.75)

How can I combine these three statements in to one cell to calculate the appropriate cost? Thanks for your assistance.

To be honest, your verbal description on a,b,c,d is not matching what you did in your formulas. Based on what I understood from your verbal description try following;

=IF(A2>F2,IF(A2-F2<=2,10,A2*4.75),IF(F2-A2<=2,10,F2*4.75))

Hope this helps.

tac