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.
×
Feb 26, 2015 | Microsoft Word Business & Productivity...
Nov 22, 2014 | Individual Business & Productivity...
Nov 29, 2010 | Microsoft Office Excel 2003 for PC
Jun 11, 2009 | Microsoft Excel for PC
Jan 09, 2009 | Microsoft Office Standard for PC
Mar 13, 2008 | Business & Productivity Software
Feb 29, 2008 | Microsoft Excel for PC
Dec 03, 2007 | Business & Productivity Software
Nov 06, 2007 | Oracle 10g Database Standard (ODBSEONUPP0)
Sep 23, 2007 | Microsoft Office Standard for PC
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
×