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?

hi rtour957,

=IF(A1="CT",N1*10,IF(A10,VLOOKUP(A1,brates,2,)," "))

isabelle

Le 2015-07-02 16:57, rtour957 a écrit :
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?

=IF(A1="CT",N1*10,IF(A10,VLOOKUP(A1,brates,2,)," "))

Just curious...

Why return a space character rather than zero or an empty string?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

hi Garry ,

Le 2015-07-02 20:56, GS a écrit :
Just curious...
Why return a space character rather than zero or an empty string?


because rtour957 says:
"I have a VLOOKUP formula =IF(A10,VLOOKUP(A1,brates,2,)," ") that works"
so...

isabelle

hi Garry ,

Le 2015-07-02 20:56, GS a écrit :
Just curious...
Why return a space character rather than zero or an empty string?


because rtour957 says:
"I have a VLOOKUP formula =IF(A10,VLOOKUP(A1,brates,2,)," ") that
works"
so...

isabelle

Sorry, Isabelle! I posted the wrong place...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

I have a VLOOKUP formula =IF(A10,VLOOKUP(A1,brates,2,)," ")

Just curious...

Why return a space character rather than zero or an empty string?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Thank you Isabelle.
The formula you provided worked exactly as I needed it to.

Artur