Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |