Hi,
I have a work book that I am using and in one cell I have the following formula;
IF(VLOOKUP(A2,lookup!$A$2:$D$2958,4,0)=0," ",F2*(1-30%))
this works great as it take the 30%. What I then need to do is take the output from cell from the revenue and commission (Both in separate columns)
This works fine when the output of the formula is a number but when “ “ I get an #value! I know I can get round this by using 0 but I want the cell to stay blank.
I am sure this is easy so any help would be great
Kele
I have a work book that I am using and in one cell I have the following formula;
IF(VLOOKUP(A2,lookup!$A$2:$D$2958,4,0)=0," ",F2*(1-30%))
this works great as it take the 30%. What I then need to do is take the output from cell from the revenue and commission (Both in separate columns)
This works fine when the output of the formula is a number but when “ “ I get an #value! I know I can get round this by using 0 but I want the cell to stay blank.
I am sure this is easy so any help would be great
Kele