Multiplying values
Evening all,
I want to figure out a function to use to calculate a value using a value given and multiply that dependant on the ‘zone’ so zone 1 needs to be multiplied by 14.8 zone 2 by 14.8 zone 3 by 19.2 etc etc. I have tried to use product and if functions but it says I’m using too many variables. Any help appreciated!
Evening all, I want to figure out a function to use to calculate a value using a value given and multiply that dependant on the ‘zone’ so zone 1 needs to be multiplied by 14.8 zone 2 by 14.8 zone 3 by 19.2 etc etc. I have tried to use product and if functions but it says I’m using too many variables. Any help appreciated! Read More