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
|
|||
|
|||
#N/A help please
I have tried to correct this formula with the ISNA, and not getting any
result, please fix what I am doing wrong! I put the ISNA in the beginning and am getting an error. I just want excel to return either a blank cell or a 0 if nothing has been entered. My formula works great other than the #N/A when nothing is in my other fields to produce my formula. =IF(ISNA($F$2="FMLA",INDEX('R:\Benefits\[Insurance Premiums for leaves.xls]Look Up Sheet'!$B$6:$E$9,MATCH(B6,'R:\Benefits\[Insurance Premiums for leaves.xls]Look Up Sheet'!$A$6:$A$9,0),MATCH(A6,'R:\Benefits\[Insurance Premiums for leaves.xls]Look Up Sheet'!$B$1:$E$1,0)),INDEX('R:\Benefits\[Insurance Premiums for leaves.xls]Look Up Sheet'!$B$2:$E$5,MATCH(B6,'R:\Benefits\[Insurance Premiums for leaves.xls]Look Up Sheet'!$A$2:$A$5,0),MATCH(A6,'R:\Benefits\[Insurance Premiums for leaves.xls]Look Up Sheet'!$B$1:$E$1,0)))) |
#2
|
|||
|
|||
#N/A help please
Show us the formula before you edited it.
best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "cadustin" wrote in message ... I have tried to correct this formula with the ISNA, and not getting any result, please fix what I am doing wrong! I put the ISNA in the beginning and am getting an error. I just want excel to return either a blank cell or a 0 if nothing has been entered. My formula works great other than the #N/A when nothing is in my other fields to produce my formula. =IF(ISNA($F$2="FMLA",INDEX('R:\Benefits\[Insurance Premiums for leaves.xls]Look Up Sheet'!$B$6:$E$9,MATCH(B6,'R:\Benefits\[Insurance Premiums for leaves.xls]Look Up Sheet'!$A$6:$A$9,0),MATCH(A6,'R:\Benefits\[Insurance Premiums for leaves.xls]Look Up Sheet'!$B$1:$E$1,0)),INDEX('R:\Benefits\[Insurance Premiums for leaves.xls]Look Up Sheet'!$B$2:$E$5,MATCH(B6,'R:\Benefits\[Insurance Premiums for leaves.xls]Look Up Sheet'!$A$2:$A$5,0),MATCH(A6,'R:\Benefits\[Insurance Premiums for leaves.xls]Look Up Sheet'!$B$1:$E$1,0)))) |
#3
|
|||
|
|||
#N/A help please
maybe:
=IF($F$2="FMLA",IF(ISNA([your lengthy formula]),"",[your lengthy formula]),"") "cadustin" wrote: I have tried to correct this formula with the ISNA, and not getting any result, please fix what I am doing wrong! I put the ISNA in the beginning and am getting an error. I just want excel to return either a blank cell or a 0 if nothing has been entered. My formula works great other than the #N/A when nothing is in my other fields to produce my formula. =IF(ISNA($F$2="FMLA",INDEX('R:\Benefits\[Insurance Premiums for leaves.xls]Look Up Sheet'!$B$6:$E$9,MATCH(B6,'R:\Benefits\[Insurance Premiums for leaves.xls]Look Up Sheet'!$A$6:$A$9,0),MATCH(A6,'R:\Benefits\[Insurance Premiums for leaves.xls]Look Up Sheet'!$B$1:$E$1,0)),INDEX('R:\Benefits\[Insurance Premiums for leaves.xls]Look Up Sheet'!$B$2:$E$5,MATCH(B6,'R:\Benefits\[Insurance Premiums for leaves.xls]Look Up Sheet'!$A$2:$A$5,0),MATCH(A6,'R:\Benefits\[Insurance Premiums for leaves.xls]Look Up Sheet'!$B$1:$E$1,0)))) |
Thread Tools | |
Display Modes | |
|
|