Thread
:
Please help me on IF function
View Single Post
#
2
Posted to microsoft.public.excel.misc
Nick Hodge
Posts: n/a
Please help me on IF function
Serene83
Try this
=IF(B1<30,"^"&A1,IF(B1<50,"*"&A1,A1))
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS
"serene83" wrote in
message ...
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
Reply With Quote