Solved

Excel equation

Posted on 2014-01-27
3
214 Views
Last Modified: 2014-01-27
hi all,

I have this is in my excel sheet

=IF(C2>=30, "2000", IF(C2>15,"520", IF(C2<=15,"400")))

this works in that it provides a result in the cell.

however, this cell is in a column of which I need a total sum. it does not read this cell??

how can I fix this?
thanks
Gareth
0
Comment
Question by:gareth629
  • 2
3 Comments
 

Accepted Solution

by:
gareth629 earned 0 total points
ID: 39814131
Got it!!

if I change the 400, 560 (was 520, just go with it), 2000 to ratios of 400 ie 1, 1.4, 5 and then add * 400 after the equation it works.

therefore - =IF(C2>=30, "4", IF(C5>15,"2", IF(C5<=15,"1")))*400

it works.
0
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 39814170
Although you have got it to work, the real problem was that you were entering text and not numbers. You should have had

=IF(C2>=30, 2000, IF(C2>15,520, IF(C2<=15,400)))

instead of

=IF(C2>=30, "2000", IF(C2>15,"520", IF(C2<=15,"400")))
0
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 39814176
BTW I just noticed that the question formula and the solved formula would yield different results.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
EXCEL Name Matching 13 37
Excel formula to append date to end of url 6 28
split data by day 21 29
Excel - Data Validation - Dynamic Weekday 11 20
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question