I have services in one column and rates in another.
I have a VLOOKUP formula =IF(A10,VLOOKUP(A1,brates,2,)," ") that works just fine and whenever a service in A1 is chosen the rate is entered based on ‘brates’ table.
One of the services however is training (code CT) and the third column is for the number of training hours so rate depends on ## of training hours.
I came up with the another IF formula =IF(A1="CT",N1*10,) that calculates total rate based on number of training hours times the base rate only when A1=CT . Both formulas work fine separately but I have difficult time combining it in one nested IF formula so bot IF conditions are taken into consideration. No matter what the correct rate is not calculated. What am I doing wrong?