I need a formula that if a cell is empty then it will used info from another cell, but then if I add text to that cell it will show that info util it is deleted and is blank again so it would revert back to the formula.
<tbody>
</tbody>
A | B | |
1 | table | 50 |
2 | chairs | 300 |
3 | none | 0 |
4 | if blank then use A3 | |
5 | if blank then use A3 |
<tbody>
</tbody>