Help with IF Function

R

R6RoadRacer

I can't figure this out for the life of me.

Cell C23 has the following formula =$C4*C12*C20*$C6

The Value of this formula is 69,672

Cell C7 is a linked cell to a value of 46,648

Here is my problem cell:

=IF(C23<$C7,$C7,C23)

The value I keep getting back is 46,648, not 69,672. The logica
argument is false, therfore I should be getting C23 which is 69,672 a
the value.

The bizarre part is that if I flip the opeartor to a greather than ">"
I get back 69,672.

I have had this problem before with nested if statements, but neve
before on a single if statement.

Some of the columns are locked for copying the function once I figur
it out, but referring back to the same cell.

Any insight? Thanks
 
R

R6RoadRacer

One more piece of info I just discovered. If I break the link in cel
C7 and manually type the value in, it works fine
 
E

Excel_Geek

What is the formula in C7? If it links to another cell -- i.e. "=C8" -
what is the value (or formula) and format of that cell
 
Top