Hi!

A1 = some number

=IF(ISNUMBER(A1),IF(A1<7,A1*100,A1*85),"")

Biff

"brian" wrote in message
. ..
Can anyone help me? I need to write a formula that will multiply the
amount
in a specified cell by 100 if the cell value is less than 7 or multiply it
by 85 if the cell value is 7 or greater. Thanks in advnce for any help!