formula for Greater of C or D X E
 

can you please help me in writing this formula

if c is greater multiply if by E, but if Dis greater then multiply D by E.

thank you

Have a look in HELP index for MAX

--
Don Guillett
SalesAid Software

"
.com wrote in message
...
can you please help me in writing this formula

if c is greater multiply if by E, but if Dis greater then multiply D by E.

thank you

=IF(C1=D1,C1*E1,D1*E1)

I figured it didn't matter which one it is multiplied by if they are equal.

" wrote:

can you please help me in writing this formula

if c is greater multiply if by E, but if Dis greater then multiply D by E.

thank you