Question about Microsoft EXCEL 2004 for Mac
=IF(K>50,(IF(K>66,A*300,A*200),10000))
Posted on Feb 24, 2009
Correction on the formula...
=IF(A>50,(IF(A>66,A*300,A*200)),10000)
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.
×
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.
goodluck!
Posted on Jan 02, 2017
Dec 08, 2016 | Office Equipment & Supplies
Dec 01, 2016 | Computers & Internet
Jan 13, 2016 | The Learning Company Achieve! Math &...
Feb 13, 2015 | Dell Optiplex GX620 Pentium 4 3.4GHz (Open...
Jul 18, 2011 | Texas Instruments TI-81 Calculator
Jul 06, 2011 | 1997 Chevrolet Venture
Jun 21, 2011 | Computers & Internet
Nov 27, 2010 | Acer Aspire 5735 Notebook
Apr 11, 2010 | Texas Instruments TI-84 Plus Silver...
Jun 23, 2008 | M2K Garfield: It's All About Math Math...
Jun 26, 2017 | Computers & Internet
Jun 26, 2017 | Lenovo Computers & Internet
87 people viewed this question
Usually answered in minutes!
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
×