Excel Tutorial - Geeks to Go Forums

Jump to content

Log in Register Register Malware removal guide How it works

Excel Tutorial Discuss About Excel Program

#1 mm_akash

  • Group: Member
  • Posts: 94
  • Joined: 20-February 05

Posted 18 April 2005 - 06:32 AM

Hi all buddies.
Cordial love to all
hope everybody is well.
Dear friends I will be happy if all of our friends are post their valuable idea about excel.
Thanks and best regards
Akash

#2 mm_akash

  • Group: Member
  • Posts: 94
  • Joined: 20-February 05

Posted 18 April 2005 - 06:35 AM

Hello.
Now i m in big problem.
Just Help me.
I just wanna know percentage formula about excel.

$400 x 61.5 = BDT 24,600
Now i just want to work out 5 % of 24,600 and want to add 525 with this result.
How can i do this in excel.
Plz help

Thanks

#3 Budha

  • Group: Member
  • Posts: 4
  • Joined: 18-April 05

Posted 18 April 2005 - 10:54 PM

To give you an idea of where I'm going, try this:

In cell A1, put 24600

In cell A2, put the following formula:

=(A1*5%)+525

The items within the brackets will be worked first (5% of any number in cell A1). 525 will then be added to that total.

When you press Enter, the cell A2 will change to 1755.

For your specific example, change cell A1 in my formula to whatever cell is appropriate on your worksheet.

Hope this helps.

Budha

#4 mm_akash

  • Group: Member
  • Posts: 94
  • Joined: 20-February 05

Posted 20 April 2005 - 05:47 AM

Thanks Budha,
I m describing my problem.
In cell A1 $ 420
In cell A2 bdt 3640
Now i want to calculate that in cell A3
<420*61.5*5/100+3640>
How can i creat a formula for that ?
I wanna use to only three cell for this calculation.

#5 Budha

  • Group: Member
  • Posts: 4
  • Joined: 18-April 05

Posted 20 April 2005 - 10:12 AM

Your formula should work just the way you have it, but put an = sign at the beginning.

So, the cells should look like:

A1
420

A2
3640

A3
=420*61.5*5/100+3640

I get 4931.5 as my answer in cell A3.

#6 mm_akash

  • Group: Member
  • Posts: 94
  • Joined: 20-February 05

Posted 07 July 2005 - 02:11 AM

Hello All budies.

How are you all ?
Long time I am not getting any help about excell problem.
Plz write down here soem important tips about excel

Regards
Akash

#7 Learnatic

  • Group: Member
  • Posts: 131
  • Joined: 20-May 05

Posted 07 July 2005 - 08:44 AM

Hi Akash.
Learning about Excel is a big job. It can't be explained in just this forum.
Use the "Help" in Excel and type in "Formula" in the index of "Help" See if this helps.

#8 mm_akash

  • Group: Member
  • Posts: 94
  • Joined: 20-February 05

Posted 23 August 2006 - 01:24 AM

Yes...learnatic...
You are right.
Nowadays I am doing like this

Share this topic: