The only way that I can replicate your problem is if I format C7 as text
prior to entering a value. If you highlight the $C7 in the formula and then
press the F9 key what do you see?

--
Sandy

Sandy

Replace@mailinator with @tiscali.co.uk


"R6RoadRacer"
wrote in message
...

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 logical
argument is false, therfore I should be getting C23 which is 69,672 as
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 never
before on a single if statement.

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

Any insight? Thanks.


--
R6RoadRacer
------------------------------------------------------------------------
R6RoadRacer's Profile:
http://www.excelforum.com/member.php...o&userid=26691
View this thread: http://www.excelforum.com/showthread...hreadid=399611