Wrong data type?

I want the product of a cell plus a number to show up in a 3rd cell, so I used the formula =G47*0.07, but the 3rd cell shows the unwanted word "value" and there's an ! that states "A value used in the formula is of the wrong data type." Is there a different formula I should use?

Hi Oceanside,

I'd expect the thing in G47 is NOT a number. You are trying to multiply text times a number. Check for the letter "Oh" in your numbers???

Marvin,
G47 formula is =IF(SUM(G21:G46)=0,"",SUM(G21:G46)). So until G21-G46 have values, G47 should be blank. G48 adds sales tax to product amount entered into G21 thru G46 and totaled in G47. G47 is a subtotal of G21 thru G46. G48 should add sales tax based on amount in G47. If I put =G47*0.07 in G48 I get the word value in the cell until a value is calculated. I don't want "value" on the sheet.

Purged my post after getting better information.

Try this:
=N(G47)*0.07

the N() function will convert the "text blank" to a zero.

Does that help?

Hi,

The "" is text. Change your formula to :
=IF(SUM(G21:G46)=0,0 ,SUM(G21:G46))

and see what happens.

Then look at the IfError function.

Hala123, thanks for the feedback