Sir,

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: jayakumarbalaji@yahoo.co.in

Thanking You.

Yours faithfully,

Jayakumar, India

Ad

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

Ad

Hi,

A 6ya expert can help you resolve that issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).

click here to download the app (for users in the US for now) and get all the help you need.

Good luck!

Posted on Jan 02, 2017

Ad

82.22222 or you could use the formula below:

(°F - 32) x 5/9 = °C

To convert (°C) Celsius to (°F) Fahrenheit use the formula below:

°C x 9/5 + 32 = °F

(°F - 32) x 5/9 = °C

To convert (°C) Celsius to (°F) Fahrenheit use the formula below:

°C x 9/5 + 32 = °F

Mar 06, 2015 | Frigidaire 30" Self-Cleaning Freestanding...

Hi enelrah_mel0,

You can create a function called SpellNumber using the Visual Basic Editor in the Microsoft Excel to spell the number.

Where A1 is the first cell in the excel sheet.

Good Luck!

Please post back the result and let me know if you require further assistance.

Thanks for using Fixya.

You can create a function called SpellNumber using the Visual Basic Editor in the Microsoft Excel to spell the number.

- Please Open Microsoft Excel. Then press Alt + F11 to open the Visual Basic Editor.
- Then, click "Insert" option above the Visual Basic Editor window and select "Module".
- Then, in the Book1 Module1 (Code) window, paste the below code there. (pasted in the next post separately for your convenience)
- Then, press Alt+Q to close the Visual Basic Editor window.
- After that, please type the formula " =SpellNumber( * )" in the Excel Sheet and press the Enter Key.
- Then, save the Excel Sheet.

Where A1 is the first cell in the excel sheet.

Good Luck!

Please post back the result and let me know if you require further assistance.

Thanks for using Fixya.

Oct 29, 2010 | IBM ThinkPad T30 2366 Notebook

Cooking ranges are generally only a 30 AMP circuit, therefore you would need number 10 gauge Wire. If the range is a 50 Amp cook top then you will need Number 8 gauge wire.

The formula to use is Watt / Volts = amps.

Below is a wire sizing chart to help.

This chart refers to copper wire and not Aluminum.

The formula to use is Watt / Volts = amps.

Below is a wire sizing chart to help.

This chart refers to copper wire and not Aluminum.

Aug 07, 2010 | Kitchen Ranges

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.

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

Put the below formula in column C1 and then drag down for other values. Please rate me if this helps. please.

=(A1* -1)

=(A1* -1)

Mar 11, 2009 | Microsoft Office Excel 2003 for PC

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:

COUNT(A1:A5)/COUNT.IF(A1:A5,"=x")*100

Example The final formula is like:

COUNT(A1:A5)/COUNT.IF(A1:A5,"=x")*100

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

Hello,

The formula should go like this:

=IF(C11>40,(C11-40)*D11,0)

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(C11>40,(C11-40)*D11*1.5,0)

If you need more help, please ask.

The formula should go like this:

=IF(C11>40,(C11-40)*D11,0)

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(C11>40,(C11-40)*D11*1.5,0)

If you need more help, please ask.

Sep 14, 2008 | Computers & Internet

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,

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 | Computers & Internet

hi there

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

http://www.contextures.com/xlFunctions02.html

All the Best.

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

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

http://www.contextures.com/xlFunctions02.html

All the Best.

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

Feb 20, 2008 | Computers & Internet

Aug 20, 2013 | Microsoft Office Standard for PC

153 people viewed this question

Usually answered in minutes!

×