Forum Discussion
If a person's name is found in a named range then execute formula
Hi, first post here, looking for some help.... Please see screenshot, could someone help me with the formula so values in F12, F13 and F14 display values that I'm after shown in C12, C13 and C14....
That could be
=B12/$A$8*(COUNTIF(FullTime,A12)>0)+B12/$B$8*(COUNTIF(PartTime,A12)>0)
Even better use not named ranges but Excel tables.
Thanks SergeiBaklan that works, much appreciated.