is it possible to make excel not process non-numeric cell data in formulae

P

perfection

Let us imagine i have 14 marks to add of a studnt but i have had to
mark absent for one or more of these - our rukle says to mark AB in
such cell
Now i have to add up on the marks i will get an error because of the
non-numeric data in one or more cells

Right now we are processing with zero and a comment inserted which is a
bit more time consuming - any way out?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top