Question about Microsoft Office Standard for PC

1 Answer

How to write a Formula


 Please help me to write a formula for the Below:


Basic Pay: 25000

Rent allowance: 30% of Basic Pay subject to Maximum of 5000


Now how to write a formula in a cell to find out Rent allowance


My Email ID:


Thanking You.


Yours faithfully,


Jayakumar, India

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 5 Answers
Re: How to write a Formula

Suppose your Basic Amount is in cell A5 then write a formula in B5 - If(A5*0.3>5000,5000,A5*.03) and copy this formula to all cells in coloumn B .

Posted on Oct 12, 2007

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

1 Answer

Copy data that contains formula and paste it to a new sheet minus the formula: is this possible?

Sure is - depending on your version of Excel.

1) right click on the cell with the formula
2) go to where you want to paste the value - minue the formula
3) right click and select paste special
4) click values (as seen in image below)

and that's it done.

If this helped you, then please help me and vote kindly.

Oct 09, 2009 | Microsoft Excel for PC

1 Answer

Trying to figure the formula below based on 9 hour work weeks and 24 hr weekends

Please be more clear with the question.. Do you want me to analyze the formula?

Feb 21, 2008 | Microsoft Excel for PC

1 Answer

Setting a Formula

You should use the formula COUNT (Cell1, Cell2), please replace Cell1 and Cell2 for the range of your cells in Excell. You could use too the formula COUNT.IF(Cell1,Cell2,Criterion), Cell1 and Cell2 is the range of cells when can exist an entry.
Example The final formula is like:

Nov 24, 2008 | Microsoft Office 2003 Basic Edition...

2 Answers

Excel formula

The formula should go like this:
This one will give you the result of (ONLY overtime hours)*(hourly wage), and if there are no overtime hours the result is 0.
Now, if you need to multiply that result with say 1,5 or whatever - insert the number you need like this:

If you need more help, please ask.

Sep 14, 2008 | Business & Productivity Software

1 Answer

Creating a formula

go to the field with the number of day formula and modify the formula just add to it this *8. The result will be in hrs.
Assuming a holiday uses 8 hrs of pay. It sounds like everyone starts with 25 holiday X 8 hrs or 200 total hours,

Jun 18, 2008 | Business & Productivity Software

1 Answer

Excel formula of vlookup

hi there
this is i found for you ...and i hope this would give you what you are looking for..

All the Best.

Was this solution helpful? Show your Appreciation by rating it:

Feb 20, 2008 | Business & Productivity Software

1 Answer

Percentage formula


Since you are asking for the formula, it depends where your values are (cell). Please refer to the example below.


Good luck and kind regards.

Dec 09, 2007 | Business & Productivity Software

2 Answers


Yes of course, if you have a little background of visual basic programming that's possible you can enhance your requirements.

Please see link

Nov 29, 2007 | Microsoft Excel for PC

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

Related Topics:

142 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides