Formula Help

[KDA123]

Hi All -

I'm looking for help with the following scenario:

Let's A1 has a numerical value, if B1 is blank, then C1 should be 3% of A1.

And, if B1 is not blank (some numerical value), then D1 should be 25% of A1.

If B1 is blank, then C1=A1*3%

Conversely, if B1>0, then D1=B1*25%

Can anyone help with the formulas for C1 and D1?

Thank you, thank you!

 

[Fluff]

Hi & welcome to MrExcel
How about
=IF(B1="",A1*0.03,"")
=IF(B1>0,B1*0.25,"")

 

[KDA123]

Hi Fluff!! Thanks for the welcome and the help. That worked perfectly!

Is there a way to add to formula so that if =IF(B1>0,B1*0.25,"") but that if B1 is blank the cell doesn't return #VALUE ! (just a blank cell would be great!)

Thanks!!

 

[Fluff]

This will remove the error
=IFERROR(IF(B1>0,B1*0.25,""),"")
But if B1 was truly blank then you would not get an error

 

[KDA123]

That worked great!

You're right...there was a formula in the cell causing the error.

Thanks for all your help, Fluff.

 

[Fluff]

You're welcome & thanks for the feedback

 

[KDA123]

Of course!

Alrighty, I've got another one if you're up for it...

Say A1 has a drop down with a series of numbers. B1 then needs to auto-populate with different numbers depending on what is selected in A1.

Ie:

1 = 101
2 = 202
3 = 303....ect.

Where 1,2, and 3 are selected from the dropdown, the corresponding values populated the adjacent cell.

And if there's any particular place you can point me with easy to understand IF statement tutorials, it'd be great to better understand this stuff.

Thanks for all your help!

 

[Fluff]

From that description
=A1*100+A1

for if functions have a look here https://exceljet.net/excel-functions/excel-if-function

 

[KDA123]

Thanks for the link, Fluff. I'm all over it, like right now.

However, i think i used a poor example, there really is no formula relationship between the number selected from the dropdown list and the number in the adjacent cell that it populates.

So, if 1 is selected in A1, then B1 populates with 1104, if 2 is selected in A1, 1656 populates.

What do you think?

 

[Fluff]

In that case it's best to start a new thread, giving exact details of what you need along with some accurate samples & explanation.