Formulas IF()

[tonyk]

trying to use IF formula on column A1:A10 "office supplies" , "janitor supplies" etc. On column D1:D10 needs to be corresponding codes from A1:A10. I have tried IF(A1:A10="office supplies",D1:D10=6999) it will work but A1:A10 are not always office supplies. How do i add more items to correspond to their own codes? What should i type in Value_if_false? Should I be use formula IF at all?
Here is the formula IF(A1:A10="office supplies",6999)

[Bob Phillips]

I think you wan to add this in D1

=IF(A1="office supplies",6999,"")

and copy down to A10


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"tonyk" <[email protected]> wrote in
message news:[email protected]...
>
> trying to use IF formula on column A1:A10 "office supplies" , "janitor
> supplies" etc. On column D1:D10 needs to be corresponding codes from
> A1:A10. I have tried IF(A1:A10="office supplies",D1:D10=6999) it will
> work but A1:A10 are not always office supplies. How do i add more items
> to correspond to their own codes? What should i type in Value_if_false?
> Should I be use formula IF at all?
> Here is the formula IF(A1:A10="office supplies",6999)
>
>
> --
> tonyk
> ------------------------------------------------------------------------
> tonyk's Profile:
http://www.excelforum.com/member.php...o&userid=35088
> View this thread: http://www.excelforum.com/showthread...hreadid=548482
>

[macropod]

Hi Tony,

For this sort of thing, you'd be better of using a lookup table in
conjunction with one of Excel's lookup functions - LOOKUP, VLOOKUP or
HLOOKUP.

Cheers

--
macropod
[MVP - Microsoft Word]


"tonyk" <[email protected]> wrote in
message news:[email protected]...
>
> trying to use IF formula on column A1:A10 "office supplies" , "janitor
> supplies" etc. On column D1:D10 needs to be corresponding codes from
> A1:A10. I have tried IF(A1:A10="office supplies",D1:D10=6999) it will
> work but A1:A10 are not always office supplies. How do i add more items
> to correspond to their own codes? What should i type in Value_if_false?
> Should I be use formula IF at all?
> Here is the formula IF(A1:A10="office supplies",6999)
>
>
> --
> tonyk
> ------------------------------------------------------------------------
> tonyk's Profile:
http://www.excelforum.com/member.php...o&userid=35088
> View this thread: http://www.excelforum.com/showthread...hreadid=548482
>

[Arvi Laanemets]

Hi

=VLOOKUP("office supplies",$A$1:$D$10,4,0)
returns the code from column D from same row where 'office supplies' is in
column A.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )


"tonyk" <[email protected]> wrote in
message news:[email protected]...
>
> trying to use IF formula on column A1:A10 "office supplies" , "janitor
> supplies" etc. On column D1:D10 needs to be corresponding codes from
> A1:A10. I have tried IF(A1:A10="office supplies",D1:D10=6999) it will
> work but A1:A10 are not always office supplies. How do i add more items
> to correspond to their own codes? What should i type in Value_if_false?
> Should I be use formula IF at all?
> Here is the formula IF(A1:A10="office supplies",6999)
>
>
> --
> tonyk
> ------------------------------------------------------------------------
> tonyk's Profile:
> http://www.excelforum.com/member.php...o&userid=35088
> View this thread: http://www.excelforum.com/showthread...hreadid=548482
>

[FSt1]

hi,
the if formula reads...if then else so your formula should be..
=IF(A1:A10="office supplies",6999,0) if office supplies then 6999 else 0.
you can string 7 ifs in the formula by simply placing another if in the
place of the 0.
=IF(A1:A10="office supplies",6999,if(janitoral,janitor code,if(widgets,
widget code,0))) and so on.
hope this helped.
regards
FSt1

"tonyk" wrote:

>
> trying to use IF formula on column A1:A10 "office supplies" , "janitor
> supplies" etc. On column D1:D10 needs to be corresponding codes from
> A1:A10. I have tried IF(A1:A10="office supplies",D1:D10=6999) it will
> work but A1:A10 are not always office supplies. How do i add more items
> to correspond to their own codes? What should i type in Value_if_false?
> Should I be use formula IF at all?
> Here is the formula IF(A1:A10="office supplies",6999)
>
>
> --
> tonyk
> ------------------------------------------------------------------------
> tonyk's Profile: http://www.excelforum.com/member.php...o&userid=35088
> View this thread: http://www.excelforum.com/showthread...hreadid=548482
>
>