IF function query - Blank cells

[graemekoz]

Good morning (or afternoon whereever in the world you are!)

I would like to have a cell input a value only if another cell has text put into it.

For example, if I had a staff roster which only gave a salary value if the name cell had been filled in, otherwise it would return a zero value.

I tried to use the following:

=IF(D3="*", F3*E3, 0.00)

but it doesn't work.

I guess what i'm asking is for the formula to do this:

If D3 contains any text, then multiply F3 by E3, otherwise return 0.00.

DOes anyone know how i can do this?

Thanks

[nika]

Hi
Just changed it a bit

=IF(D3="",0.00, F3*E3)

it now says if D3 = blank then put in 0.00 else multiply F3 by E3

hope it helps

[Kieran]

Try

=IF(istext(D3), F3*E3, 0.00)

Note that a space is treated as text, so if you need to clear a cell - dont enter space, use the delete key.