|
|
#1
02-22-2012, 09:40 AM
|
|||
|
|||
Use of MIN and count function together
Dear Sir, If I (Physically Handicapped) get Transport allowance (10 months) Rs 2000, one month I do not get anything and one month Rs 700, The answer in cell B1 should (Rs 1600X10)+ Rs 700 = 16700, One function will leave one cell blank. But if I (Physically fit) The answer in cell B1 will be (800X10)+700=8700. How to creat function so that B1 will contain all the argument together. Last edited by khokababu; 02-22-2012 at 10:32 AM. Reason: The question was no so clear. 
|
|
| Tags |
| count, min |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Count If Formula | beb1227 | Excel | 10 | 06-19-2011 11:19 AM |
 Count By Color
|
beb1227 | Excel | 4 | 06-15-2011 08:46 AM |
|
Count in Excel
|
zanat0s | Excel | 3 | 06-09-2011 10:53 AM |
| How to Count from Different Cells? | Shahzad | Excel | 3 | 06-26-2010 01:06 AM |
| Don't count 0 in a chart | Rmaisone | Excel | 0 | 08-21-2006 12:26 PM |
Windows XP 
Office 2007
Linear Mode
