Originally Posted by
thomas.szwed
I couldnt to keep the bold and italic in there you see....
Can anyone help me with this problem?
Hi,
I've added the tags for you as Arthur suggested. You aren't restricted to the number of different type of tags. All you need do is select the text of the formula and click the # icon on the message menu.
Back to your problem. You can avoid lots of IF() functions if you use INDIRECT(). Create a three column table of allowable values for C7. Put the C7 values in the first column, the range you want to use in the 2nd col. and the offset in the third column. e.g.
Name this range 'Table'
Now use the following formula
HTH
Bookmarks