Previous Topic Next Topic

Excel Formulas

Closed
grant77 Posts 1 Registration date Monday August 30, 2010 Status Member Last seen August 30, 2010 - Aug 30, 2010 at 07:07 AM
 Ray - Aug 30, 2010 at 02:01 PM
Hello,

Please help me with this ?

I know what the percentage being deducted and I know what the end total is, I would just like to know how to work out what the amount is before the percentage is deducted ? Is there a formula for this on Excel ?

eg. ? - 50% = 50

Thank you.
Related:

1 response

Answer 1 / 1
Ray
Aug 30, 2010 at 02:01 PM
Ok:

?=ANSWER/(1-(PERCENT/100))

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

Hello,
hi sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my mind...i have students total marks.now I wanna get the 1st 2nd 3rd...so on position of student leads from highest to lower one...

regards
hardy

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

Hello,

Hello,
hi sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my mind...i have students total marks.now I wanna get the 1st 2nd 3rd...so on position of student leads from highest to lower one...

regards
hardy

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

Hello
Hello, sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my mind...i have students total marks.now I wanna get the position of the students i.e first , second, third etc. I will be glad and praiseworthy if u can help me out
...

Configuration: Windows 7 / Safari 536.11

12 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

Hello,

I have got dates typed in the format following 01.08.98 and I want to change it to 01/08/1998 format. I tried applying the format we have in excel format cell date format but nothing is happening.

Please help me on this.

11 responses