multiple calcs

[bugslife]

Hi all,
I am using vlookup to pull up whole sale costs using the following formula

=IF(B17="","",VLOOKUP(B17,'Products List'!B3:D301,2,FALSE))

After it returns the value i need, i want it to multiply it by a shipping percentage located in G59 and a profit percentage in G63 . Shipping and profit percentages change day to day to day and sometimes i only need to add a shipping percentage and vice versa. Any suggestions ..please

i tried this formula
=IF(B17="","",VLOOKUP(B17,'Products List'!B3:D301,2,FALSE)*G59*G63)

but if i dont enter a value in say G59 my original figure found by Lookup doesnt show, I need it so if i dont enter a value in G59 or G63 the original value stays unchanged and is still displayed......ahhh driving me batty

 

[macleanb]

you could just replace G59 with if(G59=0,1,G59)

(etc)