Help with a formula to return a zero

		Microsoft Office Forums > Microsoft Excel > Excel
Help with a formula to return a zero

FAQ

Mark Forums Read

Thread Tools

Display Modes

10-06-2016, 01:23 AM

prihia971

Windows 10 Help with a formula to return a zero

Office 2013

Novice

Join Date: Oct 2016

Posts: 1

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?

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need a formula (possibly something like VLOOKUP) that will return multiple results.	SilverUnicorn79	Excel	8	08-16-2016 01:34 PM
Formula to return next non-blank cell in a range	Anyroad	Excel	4	09-15-2015 04:13 PM
Formula to return a date	caz46	Excel	3	04-15-2015 08:59 AM
MS Excel Investing Formula for calculating stock return HELP pls	doug6388	Excel	0	09-05-2014 08:48 PM
Excel Formula: return a range of cells that match	tinfanide	Excel	4	08-30-2014 07:03 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:59 PM.