Simple code tweak in IF function Excel

[Jyotirmaya]

=IF(A1="DEMAND",0,IF(A1="COLLECTION",0,IF(A1="BALANCE",IF(O1<=Y1,O1,IF(O1>Y1,Y1,0)))))

I am using the above formula, I want a simple change over there, in the last part IF(O1<=Y1,O1,IF(O1>Y1,Y1,0) I want that If O1<=Y1 then O1 and if O1<0 then result will be zero, I want to add this part in the code, the rest part IF(O1>Y1,Y1,0) I is ok

 

[wideboydixon]

=IF(A1="DEMAND",0,IF(A1="COLLECTION",0,IF(A1="BALANCE",IF(O1<=Y1,IF(O1<0,0,O1),IF(O1>Y1,Y1,0)))))

I think that's what you're asking for ...

WBD

 

[Jyotirmaya]

=IF(A1="DEMAND",0,IF(A1="COLLECTION",0,IF(A1="BALANCE",IF(O1<=Y1,IF(O1<0,0,O1),IF(O1>Y1,Y1,0)))))

I think that's what you're asking for ...

WBD

thanks