Jyotirmaya
Board Regular
- Joined
- Dec 2, 2015
- Messages
- 168
I want a formula that If J1 is less than 1000 and H1>0 and I1>0 then the value should be 1000-J1 else 0. I am trying this formula but getting error.
=IF(J1<1000,(AND(H1>0,I1>0)),(1000-J1),0)
=IF(J1<1000,(AND(H1>0,I1>0)),(1000-J1),0)