MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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