Blog

For 2015, a company’s expected revenue was $12000. What is the correct formula syntax in cell C7, that will return the actual value generated, if the revenue is more than $12,000? If revenue is less than $12,000 it should return 0.