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

=IF(B20>=2000,B4,B5)

============