Green arrow in cells
 

I need a addition to make this formula insert numbers as text
=IF($A9=24,"",(IF($A9=20,"190",
(IF($A9=20,"020",IF(ISBLANK(B9),"",""))))))
any ideas
Cheers

JAck

Green arrow in cells
 

Hi Jack,

There seem to be two options for when A9 = 20: 190 or 020
ISBLANK returns FALSE if there is a space in B9 or if there is a formula that returns "blank". The test seems of no use anyway,
because both TRUE and FALSE generate "".
Otherwise your formula does return numbers as text, which you seem to require. If not, leave out the quotes around the numbers.

Post back in this thread if this doesn't help.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


wrote in message ...
|I need a addition to make this formula insert numbers as text
| =IF($A9=24,"",(IF($A9=20,"190",
| (IF($A9=20,"020",IF(ISBLANK(B9),"",""))))))
| any ideas
| Cheers
|
| JAck

Green arrow in cells
 

Doesn't it do just that?

BTW, you test A9 for 20 twice.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



wrote in message
...
I need a addition to make this formula insert numbers as text
=IF($A9=24,"",(IF($A9=20,"190",
(IF($A9=20,"020",IF(ISBLANK(B9),"",""))))))
any ideas
Cheers

JAck

Green arrow in cells
 

The formula *does* give the numbers as text. You can confirm it with
=ISTEXT(cell_ref).

But note that you've got 2 conditions testing for $A9=20, so you won't get
to the "020" value.
--
David Biddulph

wrote in message
...
I need a addition to make this formula insert numbers as text
=IF($A9=24,"",(IF($A9=20,"190",
(IF($A9=20,"020",IF(ISBLANK(B9),"",""))))))
any ideas
Cheers

JAck