If a cell contains certain text then multipy two other cells

[KB2015]

Hi I am needing help with an equation on excel.

I need to create a formula that will multiply two cells if a cell has text in it.


So for example if there is text in A1 then I need to multiply B1*C1 in D1 , if theres no text in A1 it needs to stay blank


Hope that makes sense!!

[AlKey]

Try this one

=IF(ISTEXT(A1),B1*C1,"")

[KB2015]

Thank you but it seems to keep coming up saying there's an error in the formula. Not sure why.

[AlKey]

Thank you but it seems to keep coming up saying there's an error in the formula. Not sure why.

It is probably your regional settings. Try to change comma to ; semicolon

[KB2015]

That's great it has worked perfectly! Thank you for your help!

[AlKey]

You're welcome and thanks for feedback!

Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools -> Mark thread as Solved).