problem in the office

[darren grace]

Hi!
Im new in using ms excel so i dont know some basic formula in calculating...pls help me with this...


Im multiplying, a1*c1 but i need a formula that if a1 appears to be a letter not number it should proceed to b1*c1, pls solve this for me. I badly need this for work.tnx

[excelledsoftware]

It is important to continue to learn as you transition into a new role. If you are going to be using Excel a lot you will want to review basic formulas and their functionality. As for your current issue you have actually answered it already. You need an IF statement that checks if something is a number and then if it is not a number do a different calculation.

Try the following formula and fill down.

=IF(ISNUMBER(A1)+0=TRUE,A1*C1,B1*C1)

The ISNUMBER formula returns true or false. If an item is a number it will return true. Now there is a difference to an actual number and numeric. You can remove the + 0 and see if those are the results you are looking for.

Let us know how it works.

Thanks

[alfredo]

Hello, I need your help!

My problem is when i print one of my excel file all text become bold text, and i check the bold options it is not on. and when I choose my another file, i dont have problem. can i get some idea on how to sold my problem. thanks

[Pecoflyer]

Shouldn't you start a new thread instead of hijacking someone else's?