if cell x is between value a and value b

February 7, 2011 at 03:59:03
Specs: Windows 7
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

See More: if cell x is between value a and value b

Report •


#1
February 7, 2011 at 08:06:06
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.


Report •
Related Solutions


Ask Question