Add two cells if one cell is not blank

Closed
ritasinger - Jul 13, 2011 at 06:46 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 13, 2011 at 07:41 PM
Hello,
I want to add E9 and D10 if D10 is not blank (or is greater than zero), whichever is best. Can anyone help please?



1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 13, 2011 at 07:41 PM
you can try some thing like this

=if(d10>0, d10 +e9, "")
0