ExcelBanter - =IF error

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - =IF error (https://www.excelbanter.com/excel-discussion-misc-queries/257367-%3Dif-error.html)

Jim

=IF error

=IF(V2="CLC",Sales & Service Director, CLC,IF(V2="CLR",Sales & Service
Director, CLR,IF(V2="CLK",Sales & Service Director, CLK)))

Hello All,

I'm receiving an error on this formula and I can't seemt o figure out why.
Can you help?

Thanks
Jim

Jim

=IF error

I got it, missing some quotes "

Thanks

"Jim" wrote:

=IF(V2="CLC",Sales & Service Director, CLC,IF(V2="CLR",Sales & Service
Director, CLR,IF(V2="CLK",Sales & Service Director, CLK)))

Hello All,

I'm receiving an error on this formula and I can't seemt o figure out why.
Can you help?

Thanks
Jim

All times are GMT +1. The time now is 09:17 PM.