Need formula help!!!

B

brian

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!
 
D

Dana DeLouis

<lol> :>) I couldn't arrive at Sandy Mann's neat solution. The best I
got was
=A1*POWER(20/17,LOG(85)/ LOG(20/17)+(A1<7))
which isn't as nice.
(I may have my 85/100 are reversed)

If it's n*100 if n <7, maybe...

=A1*(15*(A1<7)+85)
by 100 if the cell value is less than 7 by 85 if the cell value is 7 or
greater.
Click to expand...
[/QUOTE]
 
S

sandy.mann

It was Serendipity really but if I were to think about it again I would
say:

Multiply the number in A1 by 85 and if it is more than 7 multiply it by
*a bit more* The bit more of course being 100/85. So that would give
us:

=A1*85*(100/85)^(A1>7)

Regards

Sandy
 
Top