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

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

Ask Your Question

Weekly Poll

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History