Populate a field based on the value of another field
Problem: You have a field in Excel that you want to display a predetermined value but only when another field contains specific value. Use the following formula within a given cell to populate it with 1000 if the cell A2 contains a value of 0 or more:
=IF(A2>=0,1000,IF(A2<=0,200,””))