Need a formula that will calulate column F*A, but only if column F contains a
number and not text.

Help!

A B C D E F

10% 15.58 38.50 26.68 9.43 N/A

10% 13.51 36.03 24.85 6.41 3.34

4% 8.41 28.66 20.26 4.86 N/A

4% 3.67 13.86 15.75 9.89 9.20

=IF(ISNA(F1),"",F1*A1)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"sweetsue516" wrote in message
...
Need a formula that will calulate column F*A, but only if column F
contains a
number and not text.

Help!

A B C D E F

10% 15.58 38.50 26.68 9.43 N/A

10% 13.51 36.03 24.85 6.41 3.34

4% 8.41 28.66 20.26 4.86 N/A

4% 3.67 13.86 15.75 9.89 9.20

Why not simply use the following:
=IF(ISERROR(A3*F3),0,(A3*F3))

Given that column F "may" contain a Text value which can't be multiplied and
would result in an Excel display of "#VALUE!", simply use a constant formula
which if it results in an Excel error, return a fixed value, here I've used a
value of zero if the multiplication return an error, otherwise it will return
the product of the 2 cells indicated
--
Thanks for your help -
Joe Mac


"sweetsue516" wrote:

Need a formula that will calulate column F*A, but only if column F contains a
number and not text.

Help!

A B C D E F

10% 15.58 38.50 26.68 9.43 N/A

10% 13.51 36.03 24.85 6.41 3.34

4% 8.41 28.66 20.26 4.86 N/A

4% 3.67 13.86 15.75 9.89 9.20

Thank you. They work wonderfully!

"sweetsue516" wrote:

Need a formula that will calulate column F*A, but only if column F contains a
number and not text.

Help!

A B C D E F

10% 15.58 38.50 26.68 9.43 N/A

10% 13.51 36.03 24.85 6.41 3.34

4% 8.41 28.66 20.26 4.86 N/A

4% 3.67 13.86 15.75 9.89 9.20

I believe I spoke to soon.

This is what I have using the IF statement. Hopefully this will help

=IF(ISNA(F1),"
",H8*$C$8+H10*$C$10+H12*$C$12+H14*$C$14+H16*$C$16+ H18*$C$18+H20*$C$20+H22*$C$22+H24*$C$24+H26*$C$26)

Each each colum b through f is to be multiplied by a then the total colum is
to be added together. The problem arises when I have text in a cell verses a
number
"Bernard Liengme" wrote:

=IF(ISNA(F1),"",F1*A1)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"sweetsue516" wrote in message
...
Need a formula that will calulate column F*A, but only if column F
contains a
number and not text.

Help!

A B C D E F

10% 15.58 38.50 26.68 9.43 N/A

10% 13.51 36.03 24.85 6.41 3.34

4% 8.41 28.66 20.26 4.86 N/A

4% 3.67 13.86 15.75 9.89 9.20