I am building a little spreadsheet that needs to find if an adjacent cell has a value. Then make a calculation using that value or leave blank. It seems like an easy question, but this is my first time using Numbers and the solution escapes me. Here is my formula (the one that does not work)
If B2 is blank then enter a null value, else run the calculation. If B2 is blank, then the current cell should be null or blank.