# 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!  Register To Reply

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)))  Register To Reply

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

Thank you for your assistance. The formula worked as expected.   Register To Reply

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

you are welcome  Register To Reply