Solved how to use a conditional equation (excel)

January 18, 2016 at 02:25:54
Specs: Windows 10
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


See More: how to use a conditional equation (excel)

Report •


#1
January 18, 2016 at 02:30:55
✔ Best Answer
Never mind found it, =IF(A1>50000,A1*0.05,0)

Report •
Related Solutions


Ask Question