|
|
#1
02-10-2018, 03:19 PM
|
|||
|
|||
IF Formula not returns result - Help
Hi,
Original formula: =IF($C4>=I$3,"",IF(H4="",((I$3-$C4+1)/I$1*$G4),IF($B4-SUM($H4:H4)>$G4,$G4,$B4-SUM($H4:H4)))) Changed to take out the blank colunm - No result =IF($C4>=H$3,"",(H$3-$C4+1)/H$1*$G4),IF($B4-SUM($H4:H4)<$G4,$G4,$B4-SUM($H4:H4)) Please help to identify the error on the second formula. I attached the example sheet. Thank you. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 COUNTIFS with two criteria returns wrong result
|
Ted C | Excel | 3 | 01-19-2016 07:50 AM |
|
formula, 2 criteria, one result
|
cjdstephenson | Excel | 4 | 06-02-2015 09:17 PM |
|
Formula returns wrong value
|
bobsone1 | Excel | 2 | 08-19-2014 12:12 AM |
| IF formula returns wrong result | mashley | Excel | 3 | 09-07-2012 07:03 AM |
| IF formula returns TRUE instead of evaluating COUNTIF | ColinC | Excel | 4 | 12-28-2011 08:21 AM |
Windows 8 
Office 2010 32bit
Threaded Mode