Struggling with nested functions

wrecclesham

New Member
Joined
Jul 24, 2019
Messages
45
Can someone please help me to write the following formula?

Conditions:


  • if A1 and B2 are blank
  • and A2 and B1 are NOT blank

If True:


  • = A2

If False:


  • (leave cell blank)
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
7,901
Office Version
365
Platform
Windows
You can use AND here rather than nesting:

=IF(AND(A1="",A2<>"",B1<>"",B2=""),A2,"")
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,459
Office Version
365
Platform
Windows
Perhaps.

=IF(AND(A1="", B2="", A2<>"", B1<>""), A2, "")
 

Forum statistics

Threads
1,089,661
Messages
5,409,593
Members
403,271
Latest member
Rajeev Muraleedharan

This Week's Hot Topics

Top