View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dana DeLouis
 
Posts: n/a
Default Need formula help!!!

<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.

--
Dana DeLouis

"Biff" wrote in message
...
Just for fun:

=A1*72.25*(700/595)^(1+(A17))
Sandy