In A1 we will put either yes or no
In A2 we will put some number
In A3 we want either:
A2+0
or
A2+4

In A3 enter:
=IF(A1="yes",A2+4,A2)
--
Gary''s Student - gsnu200758


"rl71066" wrote:

i want to put a drop down box in my worksheet but i am doing something very
wrong.

i want to put a yes and no in a drop down box with yes = 4 no = 0
then add what ever the number is in the next row then get the total in
another row.
like this

yes or no if yes then add it to this to come up with this
4 X the next row 15(or wahtever this number is)= this in the next row
for the life me i can not get the vlookup to work right can anyone help

thanks