| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if bigger than
Hi! I have a matrix. I want to create another matrix on the basis of the
first one. I want to check a number in a cell in the first matrix is bigger than 10. If so I want the number 1 in a cell in the other matrix. if the number in the first matrix is bigger than 20 i want the number two and so on. the problem is that is you use =if(...) it wont work for 20 becuase 20 is bigger than 10. how can i do this? any help appreciated! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| We want bigger spreadsheets | Excel Discussion (Misc queries) | |||
| Bigger spreadsheets | Excel Discussion (Misc queries) | |||
| How do I make my top margins bigger? | New Users to Excel | |||
| Excel File getting bigger | Excel Discussion (Misc queries) | |||
| Excel 2000 (9.0.6926 SP3) spreadsheet getting bigger & bigger .... | Excel Discussion (Misc queries) | |||
Threaded Mode
