If/And/OR help

[LeighEvo]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl64, width: 127"]$ Amount[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl66, width: 127"]$ Amount[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 86"]
<tbody>[TR]
[TD="class: xl66, width: 86"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD]Pool[/TD]
[TD]$2000[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl66, width: 127"]Paid in auction Bought by non-owner[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 127"]
<tbody>[TR]
[TD="class: xl66, width: 127"]Paid in auction Bought by owner[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]30%[/TD]
[TD][TABLE="width: 74"]
<tbody>[TR]
[TD="class: xl66, width: 74"]70%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 95"]
<tbody>[TR]
[TD="class: xl66, width: 95"]Status[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 122"]
<tbody>[TR]
[TD="class: xl66, width: 122"]Running Total[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Hi Guys,

i need help with my table shown.
The idea is if i type a dollar $ number in cell A3 that number will then be taken and multiplied by cell C2 (30%) and the value returned from that sum will be shown in cell C3. i also at the same time need the status column (in cell E3) to show the sum of the difference of those 2 figures (A3 - C3). In addition to this, if the first dollar $ number typed is actually in cell B3 (instead of A3 and nothing is entered into A3) i need the number entered into be multiplied by cell D2 (70%) and the value returned from that sum will be shown in cell D3 and at the same time i need the the status column (in cell E3) to show that same value displayed in cell D3 (transpose it over).

Running total will just be the pool money at the start (Cell F1 + cell E3 (status) and displayed in cell f3 and continue down the page.

thanks in advance.

 

[jtakw]

Hi,

This does what your described, but assumes that A and B can Not have a value on the Same row.
All formulas will show Blank when there's No value in either A or B.

All formulas copied down:

Book1
	A	B	C	D	E	F
1	$ Amount	$ Amount			Pool	$2,000
2	Paid in auction Bought by non-owner	Paid in auction Bought by owner	30%	70%	Status	Running Total
3	100		30		70	2070
4		150		105	105	2175
5	200		60		140	2315
6		250		175	175	2490
7	300		90		210	2700
8		350		245	245	2945
9		400		280	280	3225
10	450		135		315	3540
11
12
Sheet359

Cell Formulas
Range	Formula
C3	=IF(A3,A3*C$2,"")
D3	=IF(B3,B3*D$2,"")
E3	=IF(A3,A3-C3,D3)
F3	=IF(E3<>"",SUM(F$1,E$3:E3),"")

 

[LeighEvo]

Wow, thank you very much. a lot easier than i thought in the end. Cheers mate.

 

[jtakw]

You're welcome, welcome to the forum.