leopardhawk
Well-known Member
- Joined
- May 31, 2007
- Messages
- 611
- Office Version
- 2016
- Platform
- Windows
I have a formula that is working but I want to modify it ever so slightly. I believe I need a nested IF statement but I continue to get the #VALUE error. Here is the working formula:
I would like the formula to return B16 on its own if it contains data... here is my modified formula (which returns the error):
Any suggestions are much appreciated. Thanks!
Code:
=IF(COUNT(B16,B20)=2,SUM(B16+B20),"")
Code:
=IF(COUNT(B16)=1,B16,""),IF(COUNT(B16,B20)=2,SUM(B16+B20),"")