# IF Statement

#### BeardenS

##### New Member
I am not sure which way to do this. I was using the IF function for this particular problem, which has not worked. This is my problem:

weekly
bi-weekly
monthly

Last 3 Mo.

I need to tell Excel to look at cell B1 and if it is greater than 0 multiply by 13. But, if B1 is empty look at cell B2 and multiply by 2 then by 3 then add half of the value in cell B2. But, if B2 is empty look at cell B3 and multiply by 3.

### Excel Facts

If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

#### NBVC

##### Well-known Member
Try this.

The 6 in the formula refers to your taking B2 and multiplying by 2 and then by 3

=IF(B1>0,B1*13,IF(AND(B1="",B2<>""),B2*6+B2/2,B3*3))

#### BeardenS

##### New Member
IF

Thank You for that. It worked like a charm!!!! One question, however, where did you get the 6 from and why did you put it where you did?

#### NBVC

##### Well-known Member
As I mentioned in my previous post. I got the 6 from simplifying 2 * 3.

In your post you mention:
But, if B1 is empty look at cell B2 and multiply by 2 then by 3 then add half of the value in cell B2.

My understanding is that you are multiplying B2 by 2 and then again by 3 before adding 1/2 of B2 to that result.

Correct?

#### BeardenS

##### New Member
I apologize, I realized, after I replied, that you had answered that already.
Thank You again for your help!!!

Replies
4
Views
283
Replies
0
Views
73
Replies
1
Views
315
Replies
8
Views
242
Replies
3
Views
224

1,171,430
Messages
5,875,497
Members
433,131
Latest member
ThatOneDude

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back