LinkBack URL
About LinkBacks
HI Guys
pls help me with a code to calculate if text typed into A1= weddings or birthdays or matric farewell then B1="Yes". IF text typed into A1= Corporate then B1="No"
Thanks in advance
HI Guys
pls help me with a code to calculate if text typed into A1= weddings or birthdays or matric farewell then B1="Yes". IF text typed into A1= Corporate then B1="No"
Thanks in advance
=If(or(A1="weddings",A1="birthdays",A1="matric farewell"),"Yes",if(A1="Corporate","No",""))
type the above in B1
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Thank you alansidman for your fast and accurate response. Much appreciated!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks