formula for Greater of C or D X E

E

ELISA

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
 
S

Sloth

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

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