Math

[whiteviperx]

P5=

A5*D5=H5
H5/J5=L5
L5*N5

or ???

A5*D5=X
X/J5=Y
Y*N5=Z
P5=Z

Trying to combine the equations from row 5 into cell X5
and the same for row 9 into cell X9

and maybe even equations from row 5 and row 9 into cell X11

pc usage.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1	MAX WATT USAGE		HIBERNATE WATT USAGE	HOURS AT MAX USAGE		HOURS IN HIBERNATE		TOTAL WATTS				kW		DAYS IN YEAR		kWh		COST PER kWh		COST PER YEAR		MONTHS YEAR		COST PER MONTH
2
3
4
5	150	*		16	=			=A5*D5	/	1000	=	=H5/J5	*	365	=	=L5*N5	*	0.26	=	=P5*R5	/	12	=	=T5/V5
6
7																							+
8
9			5		*	8	=	=C9*F9	/	1000	=	=H9/J9	*	365	=	=L9/N9	*	0.26	=	=P9*R9	/	12	=	=T9/V9
10
11																							=	=X5+X9
NICK PC

Cell Formulas
Range	Formula
H5	H5	=A5*D5
L5,X9,P9,L9,X5	L5	=H5/J5
P5,T9,T5	P5	=L5*N5
H9	H9	=C9*F9
X11	X11	=X5+X9

 

[GlennUK]

Did you mean this?

Book1 (version 2).xlsb
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1	MAX WATT USAGE		HIBERNATE WATT USAGE	HOURS AT MAX USAGE		HOURS IN HIBERNATE		TOTAL WATTS				kW		DAYS IN YEAR		kWh		COST PER kWh		COST PER YEAR		MONTHS YEAR		COST PER MONTH
2
3
4
5	150	*		16	=			2400	/	1000	=	2.4	*	365	=	876	*	0.26	=	227.76	/	12	=	18.98
6
7																							+
8
9			5		*	8	=	40	/	1000	=	0.04	*	365	=	14.6	*	0.26	=	3.796	/	12	=	0.316333
10																changed
11																							=	19.29633
12
13	150	*	5	16	=	8	=	2440	/	1000	=	2.44	*	365	=	890.6	*	0.26	=	231.556	/	12	=	19.29633
14								new formula
Sheet5

Cell Formulas
Range	Formula
H5	H5	=A5*D5
L5,X13,L13,X9,L9,X5	L5	=H5/J5
P5,T13,P13,T9,P9,T5	P5	=L5*N5
H9	H9	=C9*F9
X11	X11	=X5+X9
H13	H13	=A13*D13+C13*F13

 

[whiteviperx]

In this example I'm trying to compare cost when a pc is being used vs when not being used and the total cost per month/year.... In this example its 16 hours max usage and 8 hours no usage in hibernate mode.

I saw the mistake I made with / vs * in cell p9

But I'm still trying to see how to write the equations in the least amount of cells... this just happens to be an example that I was working with for my own usage.

How can I write the whole equation from A5 to V5 into X5

 

[GlennUK]

In this example I'm trying to compare cost when a pc is being used vs when not being used and the total cost per month/year.... In this example its 16 hours max usage and 8 hours no usage in hibernate mode.

I saw the mistake I made with / vs * in cell p9

But I'm still trying to see how to write the equations in the least amount of cells... this just happens to be an example that I was working with for my own usage.

How can I write the whole equation from A5 to V5 into X5

Whole equation in one cell is: =(150*16+5*8)/1000*365*0.26/12

 

[whiteviperx]

Based on what you wrote above I came up with this

In cell X5 =(A5*D5)/J5*N5*R5/V5

In cell X9 =(C9*F9)/J9*N9*R9/V9

In cell X11 =X5+X9


But what if I wanted to write the equation from X5 and X9 into cell X11 instead?

Would it just be =(A5*D5)/J5*N5*R5/V5+(C9*F9)/J9*N9*R9/V9

or is there a simpler why to write it?

 

[GlennUK]

Well. one way to write it is very similar to yours : =A5*D5/J5*N5*R5/V5++C9*F9/J9*N9*R9/V9 - basically just removing some unneeded brackets. You can simplify it if you have the common terms hard-coded, like: =(A5*D5+C9*F9)/1000*365*0.26/12 - as 1000 365 0.26 and 12 are the same for both parts of the calculation.