With your Cost in A1:

=A1/(1-27%)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"dhnokc" wrote in message
...
Can someone tell me how to write a formula in Excel 2003 for the
following.

I currently have an item that I sell for $29.71 and my cost is $19.17
which
give me a gross profit of 35.5%. I want to lower my Gross Profit to 27%
and
need the formula to calculate my new sell price.

Thanks in advance.

Dru