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