R Ram Mher Member Aug 24, 2017 #1 Dear Friends A very simple things is not solving therefore i need help in attached sheet. Attachments if and.xlsx 143.5 KB · Views: 10
Hui Excel Ninja Staff member Aug 24, 2017 #2 In G5: =IF(AND(D5=D4,A5<>A4,C5-C4<1,G4="f"),"d","f") where the C5-C4 = 0.98541 But your comments in I5, refer to C5-C3 being greater than 1?
In G5: =IF(AND(D5=D4,A5<>A4,C5-C4<1,G4="f"),"d","f") where the C5-C4 = 0.98541 But your comments in I5, refer to C5-C3 being greater than 1?
R Ram Mher Member Aug 24, 2017 #3 Hui said: In G5: =IF(AND(D5=D4,A5<>A4,C5-C4COLOR],G4="f"),"d","f") where the C5-C4 = 0.98541 But your comments in I5, refer to C5-C3 being greater than 1? Click to expand... Sir If previous transaction status found rejected then Latest transaction to be checked from 2nd last transaction instead of previous transaction. My formula is working correct if all transaction status is accepted
Hui said: In G5: =IF(AND(D5=D4,A5<>A4,C5-C4COLOR],G4="f"),"d","f") where the C5-C4 = 0.98541 But your comments in I5, refer to C5-C3 being greater than 1? Click to expand... Sir If previous transaction status found rejected then Latest transaction to be checked from 2nd last transaction instead of previous transaction. My formula is working correct if all transaction status is accepted
