Thread: [Solved] Help with a formula to return a zero
View Single Post
 
Old 10-06-2016, 01:23 AM
prihia971 prihia971 is offline Windows 10 Office 2013
Novice
  
Join Date: Oct 2016
Posts: 1
prihia971 is on a distinguished road
Default Help with a formula to return a zero
Hi,
I'm new to excel.

I have a range AG:AJ.
Within this range there are numbers
0.25,0.50,0.75,0.00

In cell AK I have the following formula
=IF(SUM(AG12:AJ12),SUM(AG12:AJ12),"")

sometimes there might on be 0.00 within that range. I'm wanting to ensure that total (0.00) shows in cell AK and if there are no values in range AG:AJ, to leave AK blank.

Any suggestions?
Reply With Quote