I have a simple (A1*0.05),How can i make is such that if A1 is less than 50,000 the answer is 0, if greater, then the equation is solved.message edited by srdjan

message edited by srdjan

Never mind found it, =IF(A1>50000,A1*0.05,0)