=IF(K>50,(IF(K>66,A*300,A*200),10000))
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.
×
111 views
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
×