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 |
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 |