Green arrow in cells

  • Thread starter Thread starter jackcwood
  • Start date Start date
J

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
 
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
 
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)
 
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.
 
Back
Top