#### bob_lawblaw

##### New Member
Hi, I'm having a problem getting a formula correct, any help would be greatly appreciated. In words, what I would like done is:

If excel cell "BD" equals 1, copy the contents from cell "BU" (to the current cell)
If excel cell "BD" is greater than 1, add the contents of cell "BU" to (0.2)"BI"

Seems straight forward enough but nothing I try works, lol. Thanks.

### Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
Welcome to the board!

Like this?

=if(BD1=1,BU1,if(BD1>1,BU1+(0.2*BI1),"Less than 1"))

If I understand you this is the formula

=if(bd1=1,bu1,if(bd1>1,bu1+.2*bi1,"less than 1"))

What do you mean by: "Copy" and "Add"? Also, is cell "BD" a named range? Otherwise this makes no sense. Give this a go, but it does not technically "Copy" or "Add" anything.

=If(BD1 = 1, BU1, If(BD1 > 1, (.2*BI1),"Less than or equal to 1"))

This assumes that BD, BU, and BI are refering to a column reference, and you are entering the forula in row 1. HTH.

Perfect! Thank you all

Replies
1
Views
176
Replies
5
Views
121
Replies
2
Views
170
Replies
8
Views
191
Replies
3
Views
64

1,203,683
Messages
6,056,728
Members
444,887
Latest member
cvcc_wt

### 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.

### Which adblocker are you using?

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

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