MS Excel Help -- Saturation Points ?!


by ko_kidd
Tags: excel, points, saturation
ko_kidd
ko_kidd is offline
#1
Nov30-07, 04:53 PM
P: 21
Does anyone know how to do this with if-then statements or something else?

For example:

I want to analyze inflow and outflow in a tank, when the volume reaches zero then it's empty of course--so I shouldn't have a negative volume after this, volume should just be zero until I can finally get a large enough inflow. Say I'm doing this in minutes.
Phys.Org News Partner Science news on Phys.org
NASA's space station Robonaut finally getting legs
Free the seed: OSSI nurtures growing plants without patent barriers
Going nuts? Turkey looks to pistachios to heat new eco-city
berkeman
berkeman is online now
#2
Nov30-07, 05:54 PM
Mentor
berkeman's Avatar
P: 39,648
Sounds like the floor function in Excel would do what you want. Try help floor.
berkeman
berkeman is online now
#3
Nov30-07, 05:59 PM
Mentor
berkeman's Avatar
P: 39,648
Quote Quote by berkeman View Post
Sounds like the floor function in Excel would do what you want. Try help floor.
Oops, no. Foor is different. Using an IF statement would probably be best.

berkeman
berkeman is online now
#4
Nov30-07, 06:01 PM
Mentor
berkeman's Avatar
P: 39,648

MS Excel Help -- Saturation Points ?!


Quote Quote by Excel Help
=IF(logical_test,value_if_true,value_if_false)

So use =IF(cell_reference < 0, 0, cell_reference)

Here are two columns of numbers: The first is just the numbers, and the second column uses the above equation in each cell, with the cell_reference equal to the cell to its left. Just use control-d to pull the first cell equation down to all the cells in the right column to get the calculations done.

10	10
9	9
8	8
7	7
6	6
5	5
4	4
3	3
2	2
1	1
0	0
-1	0
-2	0
-3	0
-4	0
-5	0
-6	0
FredGarvin
FredGarvin is offline
#5
Nov30-07, 07:58 PM
Sci Advisor
FredGarvin's Avatar
P: 5,095
I'm not sure what your volume calcs look like, but a standard IF() function in Excel would look like:

IF(A1>0,ENTER CALC HERE,0) where A1 is the cell that would display the tank volume.
stewartcs
stewartcs is offline
#6
Dec4-07, 09:06 AM
Sci Advisor
stewartcs's Avatar
P: 2,283
You have to use VBA in Excel to use the full IF-THEN-ELSE statement.

IF dummy > 10 THEN
msgbox "dummy is greater than 10"
ELSE
msgbox "dummy is less than or equal to 10"
END IF


I'm not sure what you are asking about the rest of the question.
russ_watters
russ_watters is online now
#7
Dec4-07, 05:27 PM
Mentor
P: 22,001
No, the excel command contains the "else". It's the 3rd term in Fred's statement.

Also, my read of the question says that both the first and second terms should be the equation - first as an argument, then as an output. Ie:

=if([your function]>0,[your function],0)

But it is tough to know for sure without getting more specifics of the problem.
stewartcs
stewartcs is offline
#8
Dec4-07, 07:01 PM
Sci Advisor
stewartcs's Avatar
P: 2,283
Quote Quote by russ_watters View Post
No, the excel command contains the "else". It's the 3rd term in Fred's statement.
Never said it wasn't.

My comment was that if you want to use the full functionality to use VBA. That way you can use nested statements (a lot easier anyway), plus loops, etc... It just depends on how complicated your calculation is (or what ever you need the app to do).

If you need just one simple If-Then-Else statement, then of course the Excel function IF() would work just fine.
ko_kidd
ko_kidd is offline
#9
Dec5-07, 06:07 PM
P: 21
I guess berkeman's solution makes sense, I have to look at my excel model *later* and see if that would work. Thanks.
ko_kidd
ko_kidd is offline
#10
Dec5-07, 06:21 PM
P: 21
Here's a stripped down version of the stuff I was working on.

It's a model of the volume in a tank, ignoring how a real tank's outflow would change with the amount of mass in the tank.
CRGreathouse
CRGreathouse is offline
#11
Dec16-07, 10:30 PM
Sci Advisor
HW Helper
P: 3,680
In this particular case the IF statement is overkill. You could just use
=MAX(0, [formula here])


Register to reply

Related Discussions
CO2 saturation point? Earth 17
Saturation Vapour Pressure Classical Physics 5
Magnetic Saturation?? General Physics 1
Nuclear force saturation Introductory Physics Homework 2
Saturation current. Atomic, Solid State, Comp. Physics 1