I've been working on a computer project in Excel and i've had to use if
functions and I've had to add up rows that have if functions to a number and
i am unsure of how to do this..
ex( 1,415 is the total for a computer that is standard, they are given the
option of having an upgrade for 4 specific things an are given places to put
an "X" in and when they do they see the total. this additional total along
with the 1,415 dollars has to be added together. =IF(B18="x","$200"," " )..
and if they put an "x" in B18 they see its worth $200 but whenever i add all
of the options together including the original price it goes to just being 0.

You told it to give a result of a text string of "$200", and if you try to
add text strings you will indeed get zero. If you want a number, not a text
string, then leave out the quote marks.
--
David Biddulph

"JulieAnn" wrote in message
...
I've been working on a computer project in Excel and i've had to use if
functions and I've had to add up rows that have if functions to a number
and
i am unsure of how to do this..
ex( 1,415 is the total for a computer that is standard, they are given the
option of having an upgrade for 4 specific things an are given places to
put
an "X" in and when they do they see the total. this additional total along
with the 1,415 dollars has to be added together. =IF(B18="x","$200","
" )..
and if they put an "x" in B18 they see its worth $200 but whenever i add
all
of the options together including the original price it goes to just being
0.