| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Whats better Lookup or Function Formula
Im am trying to calculate the following. What is the best way to do it.
if C2 < C1 (value of prev row same col) and if D2="O" or "B" then F2= 1 (numeric result) else if C2 = C1 (value of prev row same col) and if D2="B" then F2= 2 (numeric result) or if D2="S" then F2= 3 (numeric result) or if D2="X" then F2= 4 (numeric result) else "Error" How would I write the formula?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel SUM function - can it be limited to whats in parentheses? | Excel Discussion (Misc queries) | |||
| Whats wrong with this OR formula? | Excel Worksheet Functions | |||
| whats wrong with the formula? | Excel Worksheet Functions | |||
| WHATS AN EASY FUNCTION TO USE TO ROUND TO THE NEAREST THOUSAND? | Excel Worksheet Functions | |||
| Whats the function to count the total times a word is displayed | Excel Discussion (Misc queries) | |||
Threaded Mode
