Question about Microsoft EXCEL 2004 for Mac

1 Answer

Applying "IF" If,'A' is greater than 66,Then K(say) = A*300 'A' greater 50, but less than 66, K=A*200 'A' less than 50 ,Then K=10000 Then how to use 'if ' function to find K

Posted by on

  • chumthungokh Feb 24, 2009

    If,'A' is greater than 66,Then K(say) = A*300
    'A' greater 50, but less than 66, K=A*200
    'A' less than 50 ,Then K=10000

    Then how to use 'if ' function to find K

×

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

=IF(K>50,(IF(K>66,A*300,A*200),10000))

Posted on Feb 24, 2009

  • bsevinc Feb 24, 2009

    Correction on the formula...
    =IF(A>50,(IF(A>66,A*300,A*200)),10000)


  • bsevinc Feb 24, 2009

    Just to let you know this is not visual basic or C++, so A and K must represent the cells in the excel. In example cell A1 could be your variable A and cell A2 is the solution K. In this case you need to put your formula in the cell A2 as:
    =IF(A1>50,(IF(A1>66,A1*300,A1*200)),10000)

    Once you put the formula, according to what you put in the cell A1, the result will show on the cell A2.


×

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

What is the name of the keyboard symbol < or >


I believe its the same as is used for mathematical nomenclature.
< = Less Then
> = Greater Then

Feb 26, 2015 | Microsoft Word Business & Productivity...

1 Answer

What is the full effect of double taxation?


Less disposable income for the average taxpayer, which causes less buying power, which decreases the expansion of the economy.

Nov 22, 2014 | Individual Business & Productivity...

2 Answers

Need formula for excel


Well the symbol for greater than would be => and for lesser than would be +<  so if you can incorporate that into your formula it should work. Something like A2=>Sheet3.

Jun 11, 2009 | Microsoft Excel for PC

1 Answer

If function in excel


Where data is in Column A1, place this in B1

=IF(AND(A1>=810001,A1<=810500),"TINU",IF(AND(A1>=810501,A1<=851000),"MINU",IF(AND(A1>=851001,A1<=852000),"PINU","")))

Jan 09, 2009 | Microsoft Office Standard for PC

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

1 Answer

=if


=IF(C5>B5,0,B5*2)
this means if it is true that C5>B5 then the cell = 0,
but if it is not true, means C5< or = B5, the cell will be B5*2
You can change the numbers as you need.
To use function easily, you can click "Insert" --> function --> then choose in the "select a function" -> OK.
Then follow the instructions. Very clear to follow

Feb 29, 2008 | Microsoft Excel for PC

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

2 Answers

Formulas


You may want COUNTIF if you're specifying criteria. For instance, if my prices are found in b3 to b7, here's a formula that will find all those that are less than 6 ($6.00):

=COUNTIF(B3:B7, "<6")

If you're using multiple criteria, such as you want to find all the prices that are greater than $5 and less than $8, the following will accomplish it. (The ABS gives you the absolute value of the result, in case the smaller number is first.)

=ABS(SUM(COUNTIF(B3:B7, ">5") - COUNTIF(B3:B7, "<8")))

Nov 06, 2007 | Oracle 10g Database Standard (ODBSEONUPP0)

1 Answer

Excel


See if this is possible using the COUNTIF formula in Excel. Example: My range is A1:A20. Lowest number being 1 and highest number being 20. To see how many are less than 10 I'd use: =COUNTIF(A1:A20,"<=10") To see how many are less than 20 but greater than 10 is a little different. (And this might be the crazy way). I do this: =SUM(COUNTIF(A1:A300,"<=20") - COUNTIF(A1:A300,"<=10")) Try this and see if it works for you. It seemed to work fine for me.

Sep 23, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft EXCEL 2004 for Mac Logo

Related Topics:

87 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

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