if Functions

J

JulieAnn

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.
 
D

David Biddulph

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the weighted average of text that have been given values 1
Prevent functions from changing when new rows are added 1
Multiple logic functions with multiple sums 2
Extracting Data from Tables 1
Date Functions & Formatting 6
Finetune formula to get currency format? 1
IF function turning text to number 4
Help Using a Combination Function 2

Top