Hi there.

I have a profile of figures i.e.

25 0 45 89 0 6

What I want to do is insert a formula that will return a 1 in the cell under the 25 (I will then multiply it by a cost figure) and return a 0 in all other cases. Basically I have a cost that is paid when production starts and it is irrelevant if there is a break in the production.

I want to put the cost all the way across in case the profile changes so when production starts it triggers this cost.

Many thanks.