Long formula with IF statement -- can't figure out how to add another item.

[daytona12345]

Here is my formula:

=IF(I5$C12,C11 ) / (C7 * 2^32/600/1000000000000) * C4 * C6 * 365


What I would like to do is add a multiplication by a percentage in the red portion above:

($C$7 * (1+A1) 2^32/600/1000000000000)

cell A1 is a percentage that I would be able to change (it could be 0% and the result stays as if the conditional isn't there, or I could change it to be 1%, 2% etc.)

I know I have a problem with the way I wrote this above due to the parenthesis -- but I've tried to write it several different ways and just can't figure out how to get that part added !

 

[SanjayGMusafir]

Here is my formula:

=IF(I5$C12,C11 ) / (C7 * 2^32/600/1000000000000) * C4 * C6 * 365


What I would like to do is add a multiplication by a percentage in the red portion above:

($C$7 * (1+A1) 2^32/600/1000000000000)

cell A1 is a percentage that I would be able to change (it could be 0% and the result stays as if the conditional isn't there, or I could change it to be 1%, 2% etc.)

I know I have a problem with the way I wrote this above due to the parenthesis -- but I've tried to write it several different ways and just can't figure out how to get that part added !

Try

((($C$7 * ((1+A1)*2))^32)/600/1000000000000)

Using Brackets will define the order of calculation you want - so please check on that while using the above part in place of red part you highlighted.

 

[daytona12345]

Try

((($C$7 * ((1+A1)*2))^32)/600/1000000000000)

Using Brackets will define the order of calculation you want - so please check on that while using the above part in place of red part you highlighted.

If I try like this it doesn't work

=IF($I$5,$C$12,$C$11) / ((($C$7 * ((1+A1)*2))^32)/600/1000000000000) *$C$4 * $C$6 * 365

Let me upload a copy of the sheet because without that, it's probably much more difficult for anyone to help!

 

[daytona12345]

=IF(I5$C12,C11 ) / (C7 * 2^32/600/1000000000000) * C4 * C6 * 365 is working and is providing the large Dollars Number.

I want to add a % increase specifically to data that is in cell C7

=IF($I$5,$C$12,$C$11) / ((($C$7 * ((1+A1)*2))^32)/600/1000000000000) *$C$4 * $C$6 * 365 did not work for me

Book2
	A	B	C	D	E	F	G	H	I
1
2
3
4		Number 1	909		Item	Rate	kWh		Check?
5		Number 2	455		1	126	3.276		TRUE
6		Number 3	24000		2	100	3.4
7		Number 4	28,174,668,481,289		3	95	3.25
8
9
10		kWh Price	$0.09			Dollars
11		RATE	36288			$1.8M
12		CHECK?	45360
13		% Change	1%
14		% Change 2	3%			#REF!
15		Item	Quantity
16		1	288		24720	25461.6	26225.448	27012.21144	27822.57778
17
18
Sheet1

 

[SanjayGMusafir]

Can't sense anything from uploaded data. Moreover unable to understand what do you want to do with IF - what are you try to tell system with IF Function

 

[daytona12345]

Can't sense anything from uploaded data. Moreover unable to understand what do you want to do with IF - what are you try to tell system with IF Function

So the basic gist of the formula is:
B16 is a Vlookup tied to the table in E, F, G

Pending what item you select (1,2,3) it will change how the rest of the calculation works.

I've copied this from google sheets so the "Check?" was actually a checkbox, so if it is False, the calculations are changed compared to if it is True.


The IF statement is essentially taking the items in 1,2,3 and when the box is ticked...it will calculate as if the machines are overclocked, if it is not checked, it will calculate as normal.


So "Rate" = not overclocked or what the formula is calculating based on if the item is FALE
Check? = this number is the overclocked number.

 

[daytona12345]

This may do the trick:

=IF($I$5,$C$12,$C$11) / ($C$7*(1+C13) * 2^32/600/1000000000000) *$C$4 * $C$6 * 365 I will check !

 

[sprigelz]

Did that work for you? With the IF statement, wouldn't you want it to state;

=IF($I$5=TRUE,$C$12,$C$11) / ($C$7*(1+C13) * 2^32/600/1000000000000) *$C$4 * $C$6 * 365

If I5 is checked (True), then C12 is displayed as the value else C11.

 

[daytona12345]

Did that work for you? With the IF statement, wouldn't you want it to state;

=IF($I$5=TRUE,$C$12,$C$11) / ($C$7*(1+C13) * 2^32/600/1000000000000) *$C$4 * $C$6 * 365

If I5 is checked (True), then C12 is displayed as the value else C11.

this works beautifully, thank you !