blank cells & #DIV/0! error

[Jeffsk]

I want to be able to copy the formulas in D2 & G2 down the columns but I have no data yet to put in B4,5,6, etc & ditto F4,5,6, etc so I get a #DIV/0! error code.

Is there any way to have the formulas in the D & G columns before having values in the B & F columns without generating the error code i.e. appearing blank until values are entered in B & F columns?

I guess this’ll probably involve the IF & BLANK functions, but although I have read about them, I’m still not sure how to use them…any clues welcome!!

TIA

Here's the Mini-sheet

Weight, IBW, BMI, %s - Copy.xlsx
	A	B	C	D	E	F	G
1	Date	AcBW (Kg)	IBW (Kg)	% above IBW	BMI	IdBMI	% above IdBMI
2	12/11/24	79.00	64	18.99	28.00	25	10.71
3	2/12/24	77.65		17.58	27.50		9.09
4				#DIV/0!			#DIV/0!
Sheet1

Cell Formulas
Range	Formula
G2:G4,D2:D4	D2	=((B2-C$2)/B2)*100

 

[Phuoc]

= If ( B2= "", "", ((B2-C$2)/B2)*100)

 

[Jeffsk]

= If ( B2= "", "", ((B2-C$2)/B2)*100)

That's done the job!
Thank you

 

[Jeffsk]

= If ( B2= "", "", ((B2-C$2)/B2)*100)

could you clarify why "", "", & not just "", ?
Thanks

 

[Joe4]

The structure of an IF statement is as follow:
=IF(condition to check, what to return if condition is true, what to return if condition is false)

So that that formula is saying is "if cell B2 is empty, then return an empty string, otherwise return your desired calculation".

See here for more details and example of the IF function: IF function in Excel: formula examples for text, numbers, dates, blanks