Please help me on IF function

[serene83]

Hi, i have a question regarding IF function.

- If item count 50 or more, do nothing
- If item count 30 to 49, add "*" behind item name
- If item count 29 or less, add "^" behind item name


Book 46
Pencil 10
Food 36
Handphone 100

Ans:
Book*
Pencil^
Food*


How do i use the IF function to get the answer above? Thank you for your help.

[Nick Hodge]

Serene83

Try this

=IF(B1<30,"^"&A1,IF(B1<50,"*"&A1,A1))

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]HIS


"serene83" <[email protected]> wrote in
message news:[email protected]...
>
> Hi, i have a question regarding IF function.
>
> - If item count 50 or more, do nothing
> - If item count 30 to 49, add "*" behind item name
> - If item count 29 or less, add "^" behind item name
>
>
> Book 46
> Pencil 10
> Food 36
> Handphone 100
>
> Ans:
> Book*
> Pencil^
> Food*
>
>
> How do i use the IF function to get the answer above? Thank you for
> your help.
>
>
> --
> serene83
> ------------------------------------------------------------------------
> serene83's Profile:
> http://www.excelforum.com/member.php...o&userid=35778
> View this thread: http://www.excelforum.com/showthread...hreadid=555463
>

[Bob Phillips]

=A1&LOOKUP(B1,{0,30,50},{"^","*",""})

--
HTH

Bob Phillips

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

"serene83" <[email protected]> wrote in
message news:[email protected]...
>
> Hi, i have a question regarding IF function.
>
> - If item count 50 or more, do nothing
> - If item count 30 to 49, add "*" behind item name
> - If item count 29 or less, add "^" behind item name
>
>
> Book 46
> Pencil 10
> Food 36
> Handphone 100
>
> Ans:
> Book*
> Pencil^
> Food*
>
>
> How do i use the IF function to get the answer above? Thank you for
> your help.
>
>
> --
> serene83
> ------------------------------------------------------------------------
> serene83's Profile:
http://www.excelforum.com/member.php...o&userid=35778
> View this thread: http://www.excelforum.com/showthread...hreadid=555463
>