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. |
if Functions
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. |
All times are GMT +1. The time now is 05:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com