Please help me on IF function

S

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.
 
B

Bob Phillips

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

--
HTH

Bob Phillips

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