Help with IF Function

[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

 

[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

 

[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

 

[Bob Phillips]

Do you get the same problem with =MIN($C7,C23)?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"R6RoadRacer" <[email protected]>
wrote in message
news:[email protected]...

 

[Sandy Mann]

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
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk


"R6RoadRacer" <[email protected]>
wrote in message
news:[email protected]...