# data selection

0

If after doing a sum cell A1 = any figure between 30.01&40 I want cell B1 to automatically become 2%

### Discussion

Please don't forget to select the answer that worked for you! Just click the Select Answer button at the bottom of the desired answer.
don (rep: 1382) Nov 22, '17 at 10:42 am

0

This requires two separate steps.

1. Enter this formula in the cell where you want the output.
``=IF(AND(\$A1>30,\$A1<=40),2%,0)``
2. Set a custom format for that same cell.
Right-click on the cell, select Format cells, select the Number tab, select Custom and write this formula in the Type field.
``0%;;``

The cell formula will either write 0 or 0.02 to the cell. This is important to know in case you wish to do calculations with this result.

The cell format willl change the value of 0.02 into 2% and hide the zero. Zero is better than "" because it is a number. If you wish to show it, remove the two semicolons from the formatting mask. The other part of the mask ("2%") determines the format of the number. You could make this "0 %" (with a space) or "0.0%" (with a decimal digit) or any other valid number format.