| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel formula writing question
If your values are listed in column A, use this formula in column B:
=IF(A1=0,"A",IF(AND(A10,A1<2.5),0,IF(AND(A1=2.5, A1<5),1,IF(A1=5,2)))) - Dan craig phila wrote: Im using Excel 2003 and I want to have the outcome in one cell contingent upon the outcome in another. Let me explain: If cell A1 = 0, then cell A2 = A If A1 = greater than 0 but less than 2.50, then A2 = 0 If A1 = 2.50 or greater than 2.50 but less than 5.00, then A2 = 1 If A1 = 5.00 or greater, then A2 = 2 Is this doable? And if so, how is it set up? -- craig phila |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need help writing a formula in excel | New Users to Excel | |||
| Help writing an Excel Formula | Excel Worksheet Functions | |||
| question about Excel file writing and reading | Excel Programming | |||
| Trouble writing an excel formula... | Excel Worksheet Functions | |||
| Writing Excel Formula To A Cell | Excel Programming | |||
Linear Mode
