How do I add 17.5% to a value stored in cell b2?
Lindsay

Cell B3 formula = "=B2 + (B2 * .175) will do it.


---
Message posted from http://www.ExcelForum.com/

=B2 * 1.175


"Lindsay Cowell" <(E-Mail Removed)> wrote in message
news:bvefnr$uto$(E-Mail Removed)...
> How do I add 17.5% to a value stored in cell b2?
> Lindsay
>
>
>
>
>
>
>
>
>
>
>

If the responses you have aren't what you meant, and you actually wanted to
change the value in B2 to B2+17.5%, then put 1.175 in a cell and copy it, then
select cell B2 and do Edit / paste special / multiply.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Lindsay Cowell" <(E-Mail Removed)> wrote in message
news:bvefnr$uto$(E-Mail Removed)...
> How do I add 17.5% to a value stored in cell b2?
> Lindsay
>
>
>
>
>
>
>
>
>
>
>


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.572 / Virus Database: 362 - Release Date: 27/01/2004