'Update only when' formula?

mjs59

New Member
Joined
Aug 20, 2004
Messages
8
Hi,

Is it possible to only update the result of a formula when a particular condition is met, for example.

The context is a Deal or No Deal Spreadsheet, i've got one massive part all working, but i'm trying to get another section working, namely a 'Live Game Guide'. I delete the particular value when it is revealed, and a range of statistics are then calculated. However i'd like to be able to compare the current situation to the previous round...

I have a 'Round' cell, this automatically updates when boxes are removed. As a means of collating other statistics i'd like to be able to make a cell only update if it matches the 'Round' cell.

eg. Round [1,2,3,4,5,6]

Action delete box value "A".

Update Box a in round 1, IF round is #1
or Update Box "A" in round 2, IF round #2....etc


Any ideas?
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Watch MrExcel Video

Forum statistics

Threads
1,113,915
Messages
5,545,016
Members
410,646
Latest member
LegenDSlayeR
Top