Please help with formula

[bob_lawblaw]

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.

 

[Oaktree]

Welcome to the board!

Like this?

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

 

[cherria]

If I understand you this is the formula

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

 

[martinee]

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.

 

[bob_lawblaw]

Perfect! Thank you all