blank cells in a formula gives me an answer not acceptable to prin

A

AL VEGA

need to insert certain statements to give a substitute answer such as NA
until the second number is inserted into the blank cell
 
M

MarkN

Hi Al,

How about =IF(ISERROR(F3/G3),"",F3/G3). If the calculation F3 divided by G3
returns an error, return "" to the cell containing the formula, if it doesn't
return an error, perform the calculation and return the result to the cell
containing the formula.
 
C

CLR

You'll have to be a little more specific in describing your needs. There
are many formulas and solutions similar to what you have started to
describe. Please post your formula that is of concern and what results you
would like for it to return. Then, someone will help.

Vaya con Dios,
Chuck, CABGx3
 

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