|Hi DerbyDad03! |
I'm not sure if it's the same issue : before I wanted to have in e.g. A1 a standard list of some fixed values to choose and additional "other" value to put in from the keyboard.
Now, I try to have a bit different situation because the values are chosen in another cell .in A1 and in B1 I have a multiple IF formula that basing on values set in A1 calculates the result:, like this: =IF(A1=0;0;IF(A1<70;14;IF(A1<130;16;IF(A1<240;18;IF(A1<300;24;33))))
Now, I intend to have in B1 the choice between "stiff" formula and free input value from keyboard, so the drop-down list having two items "FORMULA" and "OTHER".
Choosing FORMULA the value in the cell comes from the above formula and choosin OTHER I could put any value from the keyboard.
I do realise that this is a bit entangled but maybe you could help me doing something like this or similar...
Thanks a lot in advance!!