If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Using IF function when "#value!" is present.
|
#3
|
|||
|
|||
Using IF function when "#value!" is present.
|
#4
|
|||
|
|||
Using IF function when "#value!" is present.
Here's another one:
Entered as an array using the key combination of CTRL,SHIFt,ENTER (not just ENTER): =MAX(IF(ISNUMBER(A1:B1),A1:B1)) Biff wrote in message oups.com... 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 | |
Display Modes | |
|
|