Hi
i need an excel formula but cant figure out how to make it work.
=average(cell1,cell2) unless either cell is blank then just bring back the value in the cell which has a value, and if both cells are blank then I need a formula that will just make the cell blank.
Please can you help.
Thanks
Ben
i need an excel formula but cant figure out how to make it work.
=average(cell1,cell2) unless either cell is blank then just bring back the value in the cell which has a value, and if both cells are blank then I need a formula that will just make the cell blank.
Please can you help.
Thanks
Ben