View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default How do I add a formula?

On the off-chance that the 15% is included in the amount, you can use

=A1*(1-1/1.15)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jaleel" wrote in message
...
Hi,

=D1*15%

Regards,

Jaleel

"Lo" wrote:

How do I add a formula to find 15% of an amount? The amounts are listed

in
column D. I want to see 15% in Column E