Need help with an IF Formula

[Broberts1986]

Hello all im trying to figure out how to make this formula work.

=IF(F35<G35,F35,K35+L35+M35)

The cell is just returning with zero and not matching the data from the F35 Cell and also isnt providing me with the sum from the K-M Columns that trying to get.

I figure it is gonna be a simple fix as it is generally when i ask but i have been trying to figure this out for almost an hour.

[FDibbins]

what exactly is in those cells, are you sure they contain REAL values, and not text looking like numbers?
Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[alansidman]

The formula looks ok. Suggest you upload a sample workbook with a few transactions that currently do not work. In this manner, we can test and analyze what is really happening.

[Pete_UK]

It might be that the "numbers" in those cells are really text values which look like numbers, but are not real numbers. How did the values get into those cells?

Hope this helps.

Pete

[Broberts1986]

I have uploaded a test document of what i was trying to do.

im starting to think it might be more complicated then i thought.

the values in those cells are using formulas to gather the initial values.

[FDibbins]

OK here is your 1st problem (unless your file has a typo?)...

What I would like is for cell D2 to look at Cell C2 and if C2 is lower then D2

You are testing a cell to see if "itself" is less than "itself".

This is causing whats called a Circular Reference Error, and we try to avoid those as much as possible

If that was a typo in your file, what was your expected answer? (the file shows 7)

[Broberts1986]

Ok so i just looked at it more and the formula is working just fine the problem that im seeing is yes im getting a circular reference error like you are stating so what i think my best bet is to do this.

is have the formula from the spreadsheet i sent that states =SUM(B2)-SUM(H2:J2) have that in a different column day M and then have the formula =IF(C2<M2,C2,B2-(H2+I2+J2))

[FDibbins]

It doesnt really matter if you include a direct reference to that cell, or use that cell in a formula elsewhere, then reference that cell - the circ ref error is still there.

Think of it like this.

A+B =C
but
C+B=A
see the conundrum?