formula question

[celeste]

i need a formula that says:

if the value in column C is a percentage, then take c*d, if not, then take h-c

any help is appreciated. i don't know code, so if you could just let me know of the formula, that would be great!!

thanks

 

[Mark W.]

=IF(LEFT(CELL("format",C2))="P",C2*D2,H2-C2)

 

[Asala42]

Is this sufficient?

=if(C2<=1,C2*D2,H2-D2)

Adam

 

[Chris Davison]

On 2002-04-09 08:22, Mark W. wrote:
=IF(LEFT(CELL("format",C2))="P",C2*D2,H2-C2)

nice