[hl0m4n]

how do i add a function to items from a drop down list?

i want the value in b4 to be added/subtracted to the value in b1 from the drop down list.

help much appreciated, thanks guys.

[SilverII]

=if(A4="Add",B1+B4,B1-B4)

[BTM]

I believe you can relate the formula with the column you use when you tell data validation which cells to use. I know I've done this with pivot tables before, but mind is fuzzy. I don't remember it being as simple as what was just posted though

[///1M]

Originally Posted by SilverII

=if(A4="Add",B1+B4,B1-B4)

^this

[BTM]

well fuck, if it is that simple, google has failed me

[hl0m4n]

Originally Posted by SilverII

=if(A4="Add",B1+B4,B1-B4)

thanks silver, this worked for me. but how do i also add subtract in that formula so if the subtract is chosen from the drop down it performs subtraction?

with your code right now, if i choose subtract, i get a FALSE in the cell.

[jpsum]

You shouldn't get that error. It's a IF/ELSE function. If A4 does not = Add, then it subtracts.


Or you can do this if you want to be a little more proper: =IF(A4="Add",B1+B4, IF(A4="Subtract",B1-B4))

[doubleIN]

dont put a space before the second IF statement though. no spaces after commas

[hl0m4n]

thank you very much guys .

quick question though, is the formula different if i wanted to do the entire row as pictured below? when i tried to just drag the box from formula, it wouldn't compute.

[Buegie]

not exactly sure what you're trying to do but you probably want B1 to be absolute. Put your cursor on it and press F4, then try autofilling again.

[jpsum]

Starting to think you are just trolling us here. But one last help since you are an old member.

Copy what I have in C4 and then just drag and copy the rest of the rows down. The last row (13) is your answer.


This is a very hard way to do a very simple task.

[BimmerPod]

=if(sum'OP'+'Imagination')*(WTF STILL NO PICS OF CHELSEA)

you can thank me later