Two if statements and text in one cell

[jonathan92591]

Hello everyone,

Two if statements and text in one cell

--

Excel or Access version: Excel 2010

Computer operating system: Windows XP

Sample data:

Excel Workbook
	A	B
14	Total of all segments	* * * * * * * * * * * * * * * * * * * *279,332
15	Total of unique contacts	* * * * * * * * * * * * * * * * * * * *456,174
16	Difference	* * * * * * * * * * * * * * * * * * * (176,842)
17	Are we off?	Yes, Under
18	Check digit totals	* * * * * * * * * * * * * * * * * * * *410,000
19	Does check digit match?	0
Kathy's Segments

Formula(s) right now: =IF((B14-B18)=0,"Yes","No")&", "&IF(B19>0,"Over","Under")

Current result(s): 0

My goal: To show the difference between B18 and B14 as a "Yes/No, Over/Under" statement

Error message: No error message

How error occurred: No error message

Generated in: Excel

Thank you.

JT

 

[Jonmo1]

It's a circular reference.

The formula is entered in B19, it therefor cannot also refer to B19..

I think you want this in B19

=IF(B18-B14=0,"Yes","No")&", "&IF(B18-B14>0,"Over","Under")

 

[jonathan92591]

It's a circular reference.

The formula is entered in B19, it therefor cannot also refer to B19..

I think you want this in B19

=IF(B18-B14=0,"Yes","No")&", "&IF(B18-B14>0,"Over","Under")

Solved! Thank you kind sir!

JT