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!

 

[KDA123]

Thanks for the link, mate - found just what was needed and sorted it out.

Will remember to start a new thread next time (new to this forum-thing....behind the times, perhaps???)

Thanks for all your help - it worked great.

 

[Fluff]

Glad you solved it & thanks for the feedback