Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have the following if statement in one of the cells:
IF(H465=$B$6,(((($B$4)/(($D$2^$D$2)*($F$2^$F$2)))^(1/($D$2+$F$2)))),(($B$3)*((H465-$B$6)/(H465+$B$1))))) Now it is not giving me the answer that I calculate so to troubleshoot I started by inserting the value that is in cell H465 and it did give me the right answer. So my question is why if I change the value of H465 to a constant in the comparison operator does the formula work as planned but if I leave the cell reference (H465) then it does not calculate the right value. One more piece of information is that there is a formula in the H465 to calculate its value. Maybe that has something to do with it? Please help! Thanks, Ben |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Question using dates in a statement | Excel Discussion (Misc queries) | |||
SQL concatenation statement | Excel Discussion (Misc queries) | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions |