IF formula based on a bolded cell

[Armand2706]

Hi,

Is there a formula I can write to have an IF statement based on the fact that a cell is bold? For example, I'm trying to calculate the variance between two numbers only if the cell is not bold. I'm working with comparative year financial data (balance sheet/ income statement), which show a variance (between the two years' results) on the totals (for example, total asset, liability). Those totals are bolded. So I'm trying to find a formula that I can drag that would say .. If text/numbers is/are bold, no variance calculation, and if the text/numbers is/are not bold, then perform the variance calculation. I'm including an example (as a screenshot) as it's probably easier to understand what I'm trying to figure out by looking at this screenshot.
Thank you for your help!

 

[Armand2706]

Hi,

Is there a formula I can write to have an IF statement based on the fact that a cell is bold? For example, I'm trying to calculate the variance between two numbers only if the cell is not bold. I'm working with comparative year financial data (balance sheet/ income statement), which show a variance (between the two years' results) on the totals (for example, total asset, liability). Those totals are bolded. So I'm trying to find a formula that I can drag that would say .. If text/numbers is/are bold, no variance calculation, and if the text/numbers is/are not bold, then perform the variance calculation. I'm including an example (as a screenshot) as it's probably easier to understand what I'm trying to figure out by looking at this screenshot.
Thank you for your help!

Forgot to add the screenshot..

 

[JoeMo]

This will work if you make only col A entries of "Total Assets" bold.

Book1
	A	B	C	D
1		2022	2021	Var
2	Cost	100	43	-57
3	Accts Rec	213	32	-181
4	Fixed Asset	459	100	-359
5	Total Assets	772	175
Sheet1

Cell Formulas
Range	Formula
D2:D5	D2	=IF(A2="Total Assets","",C2-B2)
B5:C5	B5	=SUM(B2:B4)