Solve the problems: Write a formula to display A if A is present, display B if B is present else display None.
AnswerBot
1y
Write a formula to display A if A is present, display B if B is present else display None.
Use conditional statements to check if A or B is present
If A is present, display A
If B is present, display B
If...read more
Afiya Banu
1y
=IF(A<>"", A, IF(B<>"", B, "None"))
Help your peers!
Add answer anonymously...
Popular interview questions of Developer
Top HR questions asked in Winman Software Developer
Stay ahead in your career. Get AmbitionBox app
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+
Reviews
4 L+
Interviews
4 Cr+
Salaries
1 Cr+
Users/Month
Contribute to help millions
Get AmbitionBox app
Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.
Follow us
