| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
is there a way to write this function?
Here is basically what I want to write:
=if(G3 is the greater number of celss D6 & D2,abs(D2-D6, 10) lets say 10 is in d6 and 16 is in d2. if g3 is 10, i want the formula result to be 10. However if it is 16, i want the formula result to be 16. Due to the variables, i can't write a simple if(g3d6,10,abs(D2-D6, 10). I hope this isn't too confusing. Thanks for any help you can offer, Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
| How to write IF function in Excel 2000 when there are two conditi. | Excel Worksheet Functions | |||
| Formula to list unique values | Excel Worksheet Functions | |||
Threaded Mode
