Return formula when cell not empty

[Mcfg007]

HI

I would like help to return a formula when cell not empty.

my formula is =SUM(F2*5/100)

so i want to calculate the 5% of a value when entered on the cell, when not to remain blank.

Thanks

[AliGW]

Try this:

=IF(F2="" "",F2*5/100)

You don't need the SUM function.

[Mcfg007]

Hi AliGW it gives me an errorAttachment 779386

[AliGW]

Sorry! Comma missing:

=IF(F2="","",F2*5/100)

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

[Mcfg007]

Sorry, still gives an error

[JohnTopley]

Please see yellow banner on how to attach a sample workbook.

What error ?

[Mcfg007]

Not sure what the error is see sheet attached

Many thanks

[JohnTopley]

Where is formula / error ?

[Mcfg007]

The formula is to go to cell H2 to calculate 5% of cell F2 when is not blank

[JohnTopley]

in H2 of "January"

=IF(F2="","",F2*0.05)

Same as Ali's formula so what does not work?

[Mcfg007]

Attachment 779390 see attached.

[JohnTopley]

Cannot see attachment: post FILE with your formula and showing error!

[Mcfg007]

Excel does not allow to save it with an error. please see image attached.Attachment 779392

[JohnTopley]

I cannot view the attachment: what is the ERROR message?

See attached file:

[Mcfg007]

It worked many thanks.