Help with IF Function
 

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

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


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

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?


--
Excel_Geek


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

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

--

HTH

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


"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

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