correction of formula please............

G

Guest

C2=IF(A2+B2=0,"0",C1-A2+B2)

the above formula is which im using presently. then i came out with the one
below to eliminate the error which would occur by entering data on both
cells, A2 and B2 at the same time.

C2=IF(A2=0,C1+B2,IF(B2=0,C1-A2,IF(A2 AND B2=0,"0","ERROR")))

what i need to do is if A2 and B2 has values at the same time to show an
error message.appriciate if someone could correct the above formula.
 

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

Similar Threads

countifs Function not giving desired result with date criteria 2
Generate Payment Due Date to exclude Weekends and Public Holiday 4
need help in correcting the formula 1
use cell text in lookup function 3
Problem with a Array formula, Please help !! 6
Calculating Project Time 1
Formula help 2
VLOOKUP source values are a formula result. Getting #N/A 7

Top