Question about Microsoft Excel for PC

1 Answer

Multiply a value by a minimum amount

1 x 60 =240
2 x 60 =240
3 x 60 =240
4 x 60 =240
5 x 60 =300
6 x 60 =360
1 to 4 is multipy by 4, greater than 4 use actual number

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 67 Answers

You need a cell to put these numbers first. Lets say A1 is your reference cell where the numbers are going to be input. B1 is the cell that you are going to see the calculation. Type the following formula in B1

=IF(A1<4,4*60,A1*60)

after doing this you can put any number in A1 and it will give you the calculation in B1 as the way you wanted.

Posted on Feb 24, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

How are taxes, if any, calculated in a pro forma?


I assume that you are creating a pro-forma for others to use. Very simply, you could offer a cell that asks the user to nominate the applicable tax rate for their tax jurisdiction, or, if you know (or assume the value), place that into a cell then multiply the taxable amount by 1+the tax rate, ie I buy shoes for $4 and have a 10% tax rate. Multiply the price of the shoe by 1.04 and you have the final price, inclusive of taxes.

Usually all fees and charges are applied before the taxes are calculated., but check your local tax rules because some government levied charges may not be taxable.

Aug 31, 2014 | Microsoft Excel for PC

1 Answer

Hi all, this is more of a formating function issue which no one s


J.D.101 - I am not aware of any other way to reverse the signs on a list of numbers, other than multiplying those values by -1.

Mar 08, 2009 | Microsoft Excel 2003 (065-03992) for PC

1 Answer

How do i multiply a value by a minimum amount


I you have a row with 6 values you can get the minimum number from that area. Example:
A1: 6
A2: 8
A3: 3
A4: 9
A5: 2
A6: 7

in B2 we want to pick the smallest value in that group and multiply it with 60. This is what you type in B2

=min(A1:A6)*60

Yeah :)
that's all.... Good Luck :)



Feb 24, 2009 | Microsoft Excel for PC

1 Answer

Excel help


Maybe this is what you need:
=IF(A1="toilet",(B1*2),(IF(A1="bread",(B1*3),(IF(A1="star",(B1*4))))))
this is called "nested".
You can put nested if function maximum 7. (for more than 7, we should make another "trick")
if you put toilet in A1 then come the value B1*2
if you put bread in A1 then come the value B1*3
if you put star in A1 then come the value B1*4
Note: SUM(F16*0.3) is wrong. should be only (F16*0.3) or if you want to do sum --> SUM(F16:F20)

Apr 01, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

Excell


=if(B2>0,B2+20,0)

in this case if the value of cell B2 is greater than 0, the value will be added to 20, if its less than zero it will return the answer 0.

Mar 13, 2008 | Business & Productivity Software

2 Answers

Excel 2002 formula


Try this:

=IF((E2<38),B2*14.3, IF((E2<44),B2*15.05, IF((E2<50),B2*15.8,0)))

Note that <38 is the same as <=37. Also, you can replace the 0 at the end with empty quotes "" for a blank cell.

Dec 03, 2007 | Business & Productivity Software

Not finding what you are looking for?
Microsoft Excel for PC Logo

143 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

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Tony

Level 3 Expert

2598 Answers

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

Answer questions

Manuals & User Guides

Loading...