# How to create one formula providing a result based on specific criteria

1. ## How to create one formula providing a result based on specific criteria

Hi,

I need assistance obtaining one formula providing a result in column D on my attached example based on the following criterias:

• If a "Var" (column B) is present then the sum of "Var" & "Sep 1QFC" (column B & C) is the "Result" (column D)
• If a "Var" (column B) is not present then the sum of "PRB Forecast" & "Sep 1QFC" (column A & C) is the "Result" (column D)
• If there are zero values then result shows a "-" in the cell

Thanks!

2. ## Re: How to create one formula providing a result based on specific criteria

=if(b2<>"",b2+c2,if(b2="",if(a2+c2=0,"-",a2+c2)))

3. ## Re: How to create one formula providing a result based on specific criteria

Thank you for your assistance. The formula worked as expected.

4. ## Re: How to create one formula providing a result based on specific criteria

you are welcome

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1