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

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

suggest you check with the publishers tech support

Aug 05, 2016 | Business & Productivity Software

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.

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

Put this in E1:

=IF(A1<>0,500,IF(C1=500,0,500))

=IF(A1<>0,500,IF(C1=500,0,500))

Apr 10, 2013 | Microsoft Excel for PC

i had the same assignment..are you from STI jovannie_art?

Jun 30, 2011 | Patton & Patton Flow Charting 5 (29000U)

Need to have a greater than or equal to on one otherwise excell will get confused.

Nov 29, 2010 | Microsoft Office Excel 2003 for PC

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

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 :)

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

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)

=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...

=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.

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

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.

=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

Jan 28, 2016 | Microsoft Excel for PC

143 people viewed this question

Usually answered in minutes!

×