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
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