#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? |
#2
|
|||
|
|||
Let me see if I understand:
1 or more values i AG12:AJ12 < 0 or > 0 (1, 2 or 3 can be blank) ----> =SUM(AG12:AJ12) All values in AG12:AJ12 = 0 ----> 0 All values in AG12:AJ12 blank ----> blank |
|
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 |