• ## Other - General

### Forum Guide

by Published on 2016-11-07 12:48 AM

Getting the Most From Excelguru Forums
We take a lot of pride in providing good help, and really want our users to walk away with an answer to every question.

How the Forum Works

Using the Forum
Step 1 – Register, Activate Your Account and Log In
Before you can post a question, you must register and log into the forum. This is generally a 3-step process:

1. Register
2. Activate

If you haven’t already done so, you need to register for an account by visiting our forum registration page. Fill out the form and click on the white “Complete Registration” button.

Once you’ve submitted your registration, you will receive a confirmation email from (webmaster)@excelguru.ca. Inside that email is an activation link. Please click it to confirm ...
• ### Recent Forum Posts

#### The workbook is protected and can not be changed

.
A start would be to consider "What has changed on those computers that receive the error message, since it last worked ?" Since most...

Logit Today, 03:40 AM

#### VBA for Go to Selected worksheet and hide rest others

.

Code:
```Sub SheetHidden()
Dim ws As Worksheet
Dim sName As String
sName = Application.InputBox("Range",```
...

Logit Today, 03:35 AM

#### Add two cells but one is zero.

Amend the formula in cell S5. from:

Code:
`=IF(S3>70, S3-70,"")`
to this:
Code:
`=MAX(S3-70,0)`
...

CheshireCat Yesterday, 08:01 PM

#### Add two cells but one is zero.

.
I believe if you change the formula in S5 to : =IF(S3>70, S3-70,"0")...

Logit Yesterday, 08:00 PM

#### Add two cells but one is zero.

I would like to add cell S5 and D5 in D7. That spot will not be zero all the time, but when there is no number it gives me that 'VALUE'....

JBjarnason Yesterday, 07:24 PM