Thread: if Functions
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JulieAnn JulieAnn is offline
external usenet poster
 
Posts: 1
Default if Functions

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.