ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   formula (https://www.excelbanter.com/excel-worksheet-functions/21350-re-formula.html)

Roland

formula
 
It's not a certainty that you are trying to add 5% of 12000 to 12000, but if
that is what you are trying to do, try =(6000+6000)*1.05

"sari" wrote:

I need a formula for 6000+6000+5%=


Ragdyer

Can only see the OP through Roland"s post.

With 6000 in A1, question is whether the 5% pertains to the 6000 or the
12000.

Either one of these should work:

=A1*2.05
OR
=(A1*2)*1.05
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Roland" wrote in message
...
It's not a certainty that you are trying to add 5% of 12000 to 12000, but

if
that is what you are trying to do, try =(6000+6000)*1.05

"sari" wrote:

I need a formula for 6000+6000+5%=




All times are GMT +1. The time now is 04:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com