i want to calculate a value that is determined by a range.

EG if the total of cell x is between value a & value b then run formula

A nested IF function can test for the range between values. http://spreadsheets.about.com/od/ti...

As for the formula, just put that as the condition for a 'True' test.

Ask Your Question

Weekly Poll