Formula Modification

[Spraggs]

Hello All,
I would like to change a formula I currently have....

=IF(A6="","",IF(ISERROR(VLOOKUP(A6,Actual,13,FALSE)),-1, VLOOKUP(A6,Actual,13,FALSE)))

I want to add...
If N6="DELETE" then return 0 (zero). This wants to go after..

=IF(A6="","",

and before

IF(ISERROR(VLOOKUP(A6,Actual,13,FALSE)),-1, VLOOKUP(A6,Actual,13,FALSE)))

Any help is greatly appreciated.

Thanks Jase

 

[Jonmo1]

Try

=IF(A6="","",IF(N6="DELETE",0,IF(ISERROR(VLOOKUP(A6,Actual,13,FALSE)),-1, VLOOKUP(A6,Actual,13,FALSE))))

 

[T. Valko]

Hello All,
I would like to change a formula I currently have....

=IF(A6="","",IF(ISERROR(VLOOKUP(A6,Actual,13,FALSE)),-1, VLOOKUP(A6,Actual,13,FALSE)))

I want to add...
If N6="DELETE" then return 0 (zero). This wants to go after..

=IF(A6="","",

and before

IF(ISERROR(VLOOKUP(A6,Actual,13,FALSE)),-1, VLOOKUP(A6,Actual,13,FALSE)))

Any help is greatly appreciated.

Thanks Jase

What version of Excel are you using?

 

[Spraggs]

Thanks Jonmo. Perfect.