Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello I know that I can do a formula like:
$B2$K$1 in the formula box to apply a DF all cells in column B where the value is higher than the value in K1. Good. Now what I was asked to do is to put the comparison operator in a cell ... as well! This way the user can change the number in K1 but the conditional operator too which, say, is in K2. So K1 contains 3500 and K2 contains and I want to do a formula in the CF formula box. The user can change the value in K1 and type or < in K2 and the CF will update. It is interesting that in any cell I can to a simple concatenation like "="&$B2&$K$2&$K$1 and pressing Enter displays =45006000 I have played with indirect a bit to create a reference in a concatenation. It seems that CF can only accept a real formula and not a one built as the result of an expression. Any idea? Thank you. -- Daniel |