Addition with 2 formulas in one

[justn]

Hi, new to this forum and excel. I'm starting to understand the basics with the formulas but this one I can't figure out. I need to take 2 numbers and if they are greater than 50 divide by 20, if less than 50 divide by 10, then add 2 other set of numbers separately and then add my answers to get a final answer.

Thanks in advance

 

[etaf]

you can use IF to do that

but just need the detail

you have cells with two numbers and when added together is that what we are trying to evaluate ?

so assume cells are a1 and a2

=IF( (A1+A2) > 50 , (A1+A2)/20 , (A1+A2)/10 )

where are the other numbers - ?

need the detail and what to do if the result is 50 ?

 

[justn]

Thanks for the quick response etaf, ok this is what i want to do maybe i didnt explain it right.I'll try again, first i want to subtract (A1-A2) if this result is >50 i want to divide the # by 20, if the number is <50 i want to divide the number by 10 and then i want to add this # to lets say (A3+A4)

I'm trying to get an answer then dividing that answer by either a 20 or 10 depending if its >50 or <50 then adding it to the answer from (A3+A4)

 

[Jonmo1]

Perhaps

=IF(A1-A2 > 50,(A1-A2)/20,(A1-A2)/10)+(A3+A4)

 

[etaf]

ADVERTISEMENT

=IF(A1-A2 > 50,((A1-A2)/20)+(A3+A4),(A1-A2)/10)+(A3+A4))

what happens if it = 50 ?

 

[justn]

Sorry should be greater or equal to 50 divide by 20

 

[etaf]

ADVERTISEMENT

=if(a1-a2 >= 50,((a1-a2)/20)+(a3+a4),(a1-a2)/10)+(a3+a4))

 

[justn]

they both work great but one question how do i get the larger number to be used first when subtractiing I found this from someone =max(A1:B1)-min(A1:B1) but how do i incorporate it all in 1 line

 

[Jonmo1]

Change all refs to A1-A2 to ABS(A1-A2)

 

[justn]

tried =IF(ABS(A1-A2) > 50,ABS(A1-A2)/20,ABS(A1-A2)/10)+(A3+A4) window pops up with an error, sorry about the questions Jonmo1 maybe formula to complicated for a newbie..lol