#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
You have a circular reference in H4.
|
#3
|
|||
|
|||
Thank you xor. Can you help to make the second formula to work please?
|
#4
|
|||
|
|||
Please explain in words what you want and show the results expected.
|
#5
|
|||
|
|||
Quote:
It will be easier if you don't mind to open up my example sheet attached. In the first tab, the formula worked perfectly with the right result. In the second tab, when I took out the blank column and changed the formula. The result failed. It maybe a bit hard to put this into words. Really appreciate your help. Thank you |
#6
|
|||
|
|||
Can't you just hide column H in Sheet1?
|
#7
|
|||
|
|||
Maybe I have to do that then. 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 |