Trouble with making a formula..Help!

[onequestion]

I am trying to make a formula that would kinda go something like this -
ok so
say a2=5
and b2=6
and c2=3

I want a formula that would take the greater number of either a2 or b
then divide that number by c2

cells A2 and B2 are both going to contain there own formula and cell C
is going to equal the sum of another cell....I know that the formula i
going to have to contain an IF but i kinda just dont know how to mak
it say what i want....so if you arent confused by the end of readin
this i would appreciate some help cause i sure am confused at the en
of typing this!!! lol

Thanx for listening

 

[Rockee052]

Hi Onequestion,

Would this work for you..?
=IF(A2>B2,A2/C2,IF(B2>A2,B2/C2,""))

Rocke

 

[onequestion]

I dunno Im gunna have to write it down and bring it into work....however
i might have figures out an easier way!!

I think it would work to say =MAX(A:B)/C

That, i hope anyway, will take the greater of either a or b and divide
that by C.....I am just frustrated cause i do not currently have Excel
on my home puter so now i have to wait till morning to see if it works!
Grrr

Thanx so much for replying!!! i will try both in the morn

 

[Rockee052]

That works as well,

Good luck


Rockee Freema

 

[onequestion]

Thanx a Million! I can finally go to sleep!!!! you have solved my
insomnia!

Have a wonderful night!!!!

 

[Rockee052]

Me again,

Not sure if my message worked...

Make sure you include your arguments in yor formula.
I.e., =Max(A2,B2)/C2..

Good Luck

Rockee Freema

 

[Roger Govier]

Hi

Try
=MAX(A2:B2)/C2