Joining two formulas

[brianaclark1967]

Hi Guys,

I have a spreadsheet that imports delivery costs.

If cell F81 contains the word "Delivery" then this formula searches for the delivery cost

=IFERROR(INDEX(BC:BC,MATCH(F97,BB:BB, 0)), 0)

But Id also like to add that if F81 contains the word "Collection" then it returns a "0" zero result instead.

Any help would be greatly appreciated

Regards

Brian

 

[Khalid NGO]

Hi Brian,

You can add an IF statement, exactly like you said:

=IF(F81="Collection",0,IFERROR(INDEX(BC:BC,MATCH(F97,BB:BB, 0)), 0))

See the red bold part.

I suggest to not use the full column range, it may slow down your calculation.

Regards,

 

[santoshbhagade]

You can do this via IF function
=IF(F81="Collection",0,<Current formula>)
refer the text in bold

 

[brianaclark1967]

Hi Brian,

You can add an IF statement, exactly like you said:

=IF(F81="Collection",0,IFERROR(INDEX(BC:BC,MATCH(F97,BB:BB, 0)), 0))

See the red bold part.

I suggest to not use the full column range, it may slow down your calculation.

Regards,

Thank you Khalid,

Really helpful, much appreciated.

Regards

Brian