My First Question

[Apexwolf]

I am relatively new to Excel (using it for the past year) and have an issue I cannot seem to find a solution to. "=IF((H12-H14)*1000<0,0,(H12-H14)*1000)" I have this equation in a cell when I use one of my dial indicators at work, the problem is I have a second dial indicator that reads backwards. So instead of having to manually flip both H12-H14 is there a way I can tell this cell which dial indicator I'm using and then it uses the correct formula? Let me know if my question is not clear. Thank you.

 

[dreid1011]

OK, That formula is fantastic, works perfect. The =IF formula @dried1011 suggested only returns #NAME?. Here is what I tried.

Bulk for export from Benton & Winchester.xlsx
	G	H	I	J
10	SPECIMEN INUNDATION
11	distilled water for 24 h or expantion rate < 0.0002 in./h	Height (in)	Time (h:m)	Date
12	Initial	0.2820	18:41	06/17/24
13	Reading	0.2610	9:10	06/18/24
14	Final Reading	0.2150
15	EI (measured)	#NAME?
EI FORM

Cell Formulas
Range	Formula
H15	H15	=IF(J15=A,(MAX((H12-H14)*1000,0)),(MAX((H14-H12)*1000,0)))

Yes, what I suggested was a very general idea of the logic behind the formula, not specific syntax. That would be why you are getting the error. As Joe has shown, the "A" should be in double quotes.

 

[Apexwolf]

That is because it does not recognize A here:

=IF(J15=A

If you are checking for a value of "A", it needs to be inside double-quotes, i.e.

=IF(J15="A"

Literal values always needs to go between double-quotes.
Otherwise, it thinks it is a function or range reference.

AHHH. OK. Nice thank you. Works perfect. Man am I glad I found this community.

Bulk for export from Benton & Winchester.xlsx
	G	H	I	J
10	SPECIMEN INUNDATION
11	distilled water for 24 h or expantion rate < 0.0002 in./h	Height (in)	Time (h:m)	Date
12	Initial	0.2820	18:41	06/17/24
13	Reading	0.2610	9:10	06/18/24
14	Final Reading	0.2610	11:18	06/18/24
15	EI (measured)	21		a
EI FORM

Cell Formulas
Range	Formula
H15	H15	=IF(J15="A",(MAX((H12-H14)*1000,0)),(MAX((H14-H12)*1000,0)))

 

[Cubist]

I think you should be able to do

=ABS(H12-H14)*1000

 

[Scott Huish]

=MAX((IF(J15="A",H12-H14,H14-H12))*1000,0)

 

[Scott Huish]

I think you should be able to do

=ABS(H12-H14)*1000

I thought of that but you will never end up with a result less than 0 that way. It's why I didn't do it.

 

[Cubist]

I thought of that but you will never end up with a result less than 0 that way. It's why I didn't do it.

Isn't that's the point with MAX(0,...)?

 

[Cubist]

=MAX((IF(J15="A",H12-H14,H14-H12))*1000,0)

I don't see the point of J15="A" or the 0.

=MAX(H12-H14,H14-H12)*1000

 

[dreid1011]

I don't see the point of J15="A" or the 0.

=MAX(H12-H14,H14-H12)*1000

The point of J15="A" is because OP uses 1 of 2 different measuring devices, and which one determines if it's H12-H14 or H14-H12. I don't think checking which one is larger is what OP is after, except only using values greater than or equal to 0.

 

[Scott Huish]

He has 2 different sets of numbers, watch this. Not the same thing

Book1
	H	I	J	K	L	M
12	14				5000	0
13
14	19
15			A
16
Sheet1

Cell Formulas
Range	Formula
L12	L12	=ABS(H12-H14)*1000
M12	M12	=MAX((IF(J15="A",H12-H14,H14-H12))*1000,0)

 

[Cubist]

I misunderstood the question.