| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using IF function when "#value!" is present.
I have a problem. I think it can be solved with the IF funciton.
I need to choose between the greater value in two cells to appear in a third cell. Because of how the data is procured: every so often only one of the two cells has a value in it and the other has "#VALUE!" and the IF Function breaks down. in that situation i just need the one value that exists Is there a way to do this? dan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill Function to next Column | Excel Worksheet Functions | |||
| VBA | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Threaded Mode
