Green arrow in cells

[jackcwood]

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

 

[Niek Otten]

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


|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

 

[Bob Phillips]

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)

 

[David Biddulph]

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.