Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MS Excel add result function 1
- Thread starter PPJOSEPH
- Start date
-
1
- #2
SkipVought
Programmer
hi,
This is an MS Access formu, no MS Office/Excel.
You might want forum68.
[tt]
I want to add C2 and B3 and have the result in C3. However if B3 is zero, then the result in C3 should be zero.
C3: =if(b3=0,c3,c2+b3)
[/tt]
Skip,
[sub]
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
Just traded in my old subtlety...
for a NUANCE!![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
[/sub]
This is an MS Access formu, no MS Office/Excel.
You might want forum68.
[tt]
I want to add C2 and B3 and have the result in C3. However if B3 is zero, then the result in C3 should be zero.
C3: =if(b3=0,c3,c2+b3)
[/tt]
Skip,
[sub]
Just traded in my old subtlety...for a NUANCE!
[/sub]- Status
Similar threads
