Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
Error of slope taking into account error of the data points | Excel Worksheet Functions | |||
Error: "Excel encountered an error and had to remove some formatti | Excel Discussion (Misc queries) | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions |