If cell has a value, then another cell remains blank...

This is my 1st time working with IFs and I have no idea what I am doing

This is what I want to achieve...
If...
B2 = any numerical value then C2 remains blank
B3 = any numerical value then C3 remains blank
B4 = any numerical value then C4 remains blank
B5 = remains blank then C5 will compute the equation inside that cell


B2 = any numerical value then C2 remains blank
B3 = any numerical value then C3 remains blank
B4 = remains blank then C4 will compute the equation inside that cell
B5 = any numerical value then C5 remains blank


B2 = any numerical value then C2 remains blank
B3 = remains blank then C3 will compute the equation inside that cell
B4 = any numerical value then C4 remains blank
B5 = any numerical value then C5 remains blank


B2 = remains blank then C2 will compute the equation inside that cell
B3 = any numerical value then C3 remains blank
B4 = any numerical value then C4 remains blank
B5 = any numerical value then C5 remains blank


I am attaching my spreadsheet so you can see what the equation is inside each cell.

Zac

Like this?

Chech attachment, see if it helps you

Originally Posted by Andrew-R

Like this?

Thank you very much! That is exactly what I was looking for.

Where is there some kind of tutorial for stuff like this?

Sorry, I don't know of any tutorials - I've just been using Excel a long time. I'd recommend sticking round here, though - I've learned a huge amount from this forum.