Add two cells if one cell is not blank

Closed
ritasinger - 13 Jul 2011 à 18:46
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 13 Jul 2011 à 19:41
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 28 January 2010 Status Contributor Last seen 5 May 2022 766
13 Jul 2011 à 19:41
you can try some thing like this

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