Thread
:
multiple conditions
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Sanjiv
external usenet poster
Posts: 8
multiple conditions
I have :
A B
1 10
2
3 11
4 11
5 10
I want to write a formula in Col A that
If B=10 then in col A1= have a value say "AB"
if B=11 then in col A1= have a value say "xy"
else
Col A1=blank
Kindly help and many thanks for that.
Reply With Quote
Sanjiv
View Public Profile
Find all posts by Sanjiv