fixing formula if

[abdelfattah]

hello
i have this formula but it gives me error =IF(D2:D99="";F1:F99="";(F2+D3)-E3) i have value in column d, e i would showing empty cell in column f if col d,e ="" and if is not it applys this formula =(F2+D3)-E3) so this formula changes in column d,e contain values so it should this = =(F3+D4)-E4) ,=(F4+D5)-E5) and so on

 

[Dave87]

1st thing semi colons don't work in formulas, use commas

what exactly are you trying to accomplish here, your formula doesnt make any sense. IF D2:D99 is blank what do you want to happen?

Are you trying to say IF cells D2:d99 are blank AND F1:F99 is blank you wish to calculate F2+d3-E3

 

[sandy666]

1st thing semi colons don't work in formulas, use commas

semicolon and comma works in formula, depends on region/country/excel language

 

[abdelfattah]

hi, dave about semi colon my version office 2010 doesn't work comma with any formula
input

المصنف1 (version 1).xlsb
	D	E	F
1	debit	credit	balance
2	2000	0	2000
3		500	1500
4	100		1600
5			1600
6			1600
7			1600
8			1600
9			1600
10			1600
11			1600
12			1600
sheet2

Cell Formulas
Range	Formula
F2	F2	=D2-E2
F3:F12	F3	=(F2+D3)-E3

output

المصنف1 (version 1).xlsb
	D	E	F
1	debit	credit	balance
2	2000	0	2000
3		500	1500
4	100		1600
5
6
7
8
9
10
11
12
13
sheet2

Cell Formulas
Range	Formula
F2	F2	=D2-E2
F3:F4	F3	=(F2+D3)-E3

as you see col e,d no values shouldn't repeat the last value in col f

 

[Dave87]

Ok, paste this formula in cell F3 and drag down

=IF(AND(ISBLANK(D3);ISBLANK(E3));"";(F2+D3)-E3)

 

[abdelfattah]

well done, Dave that's what i'm looking for