Prev: Thanks
Next: Excel 2007: Vlookup Problem
From: Roger Govier on 9 Jan 2010 05:56
Hi

With 100 in A1 and 6% in B1
=A1*(1+B1)

--
Regards
Roger Govier

"Sandeep Lohchab" <sandeeplohchab(a)yahoo.com> wrote in message
news:eMBKmFKkKHA.1652(a)TK2MSFTNGP05.phx.gbl...
> I found it in help. its floor function =FLOOR(C1, 0.05)
> one more thing sir, is there any easier formula than this???
> =A1/100*B1/100*100+A1
> actually i want to know 6% of 100 and also add to it.
>
> thanks in advance.
>
>
> "Sandeep Lohchab" <sandeeplohchab(a)yahoo.com> wrote in message
> news:u7o6J8JkKHA.1536(a)TK2MSFTNGP06.phx.gbl...
>> Sir, I have a row in excel with cells containing 88.23, 89.01, 72.39,
>> 54.52 and I want to know which fuction/formula to use for making these as
>> 88.25, 89.00, 72.40, 54.50. Please help. Thanks.
>>
>
>
>
> __________ Information from ESET Smart Security, version of virus
> signature database 4755 (20100108) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>

__________ Information from ESET Smart Security, version of virus signature database 4755 (20100108) __________

The message was checked by ESET Smart Security.

http://www.eset.com



First  |  Prev  | 
Pages: 1 2
Prev: Thanks
Next: Excel 2007: Vlookup Problem