One More on Conditional Number
Posted by Jon Swanson on February 13, 2002 11:10 AM
I need the cell to equal b4 if b20 is over 2000 or if it is below 2000 i need the cell to equal b5, Does anyone know how to do this one, it shouldn't be to bad, but alas I am an idiot...
Posted by Aladin Akyurek on February 13, 2002 11:21 AM
=(B20>=2000)*B4+(B20 < 2000)*B5
or with IF
=IF(B20>=2000,B4,B5)
============
