Not to Exceed issue

[Anonymous]

I am Trying to create a Work in Progress Backlog report using WIP Accounting practices. Where I am getting stuck is the not to exceed portion. I have a table that reflects the following fields. Estimated Reveue, Total Job Cost, and Recognized Revenue

Estimated Revenue is the amount we believe we are going to be paid for the job

Total Job Cost is the amount currently Spent in Cost on the job

Recognized Revenue is (Total Job Cost / 0.40 (Target Profit Margin))

I need help with the formula to make sure (Recognized Revenue does not exceed Estimated Revenue)

[Gysbert_Wassenaar · Accepted solution]

Perhaps rangemin([Recognized Revenue], [Estimated Revenue])

[Anonymous]

That worked Thank you.