Conditional Function

  • Thread starter Thread starter gte478p
  • Start date Start date
G

gte478p

I am having trouble doing this. I will try to explain this as best as
can. I have a list of values and in order to calculate the value tha
will be in G30, i need to compare the value in F30 with a list o
values which will determine what F30 needs to be multiplied by. doe
that make sense? for example, if 0<F30<=5, then F30*6, or 5<F30<=15
then F30*7, etc.
Thanks
 
Create a column of values, say C, with 0,5,15, etc.
Create a column of values, D, with 6,7,8, etc.

Your function is then
=F30*VLOOKUP(F30,C1:D10,2)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top