software

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

Help!

ABCDEF

10.5838.5026.689.43N/A

10.5136.0324.856.413.34

4%8.4128.6620.264.86N/A

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

quot;sweetsue516quot; gt; wrote in message
news
gt; Need a formula that will calulate column F*A, but only if column F
gt; contains a
gt; number and not text.
gt;
gt; Help!
gt;
gt; A B C D E F
gt;
gt; 10% 15.58 38.50 26.68 9.43 N/A
gt;
gt; 10% 13.51 36.03 24.85 6.41 3.34
gt;
gt; 4% 8.41 28.66 20.26 4.86 N/A
gt;
gt; 4% 3.67 13.86 15.75 9.89 9.20
gt;
Why not simply use the following:
=IF(ISERROR(A3*F3),0,(A3*F3))

Given that column F quot;mayquot; contain a Text value which can't be multiplied and
would result in an Excel display of quot;#VALUE!quot;, 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 Macquot;sweetsue516quot; wrote:

gt; Need a formula that will calulate column F*A, but only if column F contains a
gt; number and not text.
gt;
gt; Help!
gt;
gt; ABCDEF
gt;
gt; 10.5838.5026.689.43N/A
gt;
gt; 10.5136.0324.856.413.34
gt;
gt; 4%8.4128.6620.264.86N/A
gt;
gt; 4%3.6713.8615.759.899.20
gt;

Thank you. They work wonderfully!

quot;sweetsue516quot; wrote:

gt; Need a formula that will calulate column F*A, but only if column F contains a
gt; number and not text.
gt;
gt; Help!
gt;
gt; ABCDEF
gt;
gt; 10.5838.5026.689.43N/A
gt;
gt; 10.5136.0324.856.413.34
gt;
gt; 4%8.4128.6620.264.86N/A
gt;
gt; 4%3.6713.8615.759.899.20
gt;

I believe I spoke to soon.

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

=IF(ISNA(F1),quot;
quot;,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
quot;Bernard Liengmequot; wrote:

gt; =IF(ISNA(F1),quot;quot;,F1*A1)
gt; best wishes
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;sweetsue516quot; gt; wrote in message
gt; news
gt; gt; Need a formula that will calulate column F*A, but only if column F
gt; gt; contains a
gt; gt; number and not text.
gt; gt;
gt; gt; Help!
gt; gt;
gt; gt; A B C D E F
gt; gt;
gt; gt; 10% 15.58 38.50 26.68 9.43 N/A
gt; gt;
gt; gt; 10% 13.51 36.03 24.85 6.41 3.34
gt; gt;
gt; gt; 4% 8.41 28.66 20.26 4.86 N/A
gt; gt;
gt; gt; 4% 3.67 13.86 15.75 9.89 9.20
gt; gt;
gt;
gt;
gt;