Excel Multiple

[ajedrzej]

Hey guys was wondering...

I'm putting together an excel spreadsheet, this is what I want to do...

I have two formulas

=(F4*65)/1000

&

=(F6*26)

but I want them in one box and I want the cell to choose the higher number..

is this possible?

as you can see, the two formulas are taking numbers out of two different cells..


please help =)

much thanks!

Alesia

 

[gsistek]

=max((f4*65)/1000,(f6*26))

 

[VoG]

Try

=MAX((F4*65)/1000,F6*26)

 

[ajedrzej]

ahh EUREKA!

thank you guys so much!

=)