| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
correction of formula please............
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. |
|
#2
|
|||
|
|||
|
See reply to your earlier post.
In article , "azmi" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
| Frequency formula | Excel Worksheet Functions | |||
| Formula correction HELP!!! | Excel Worksheet Functions | |||
| formula correction | Excel Worksheet Functions | |||
Hybrid Mode
