Formula to return different values

carlycrisp

Hello,

I am trying to write a formula to return one value if a certain criteria is met, and a different value if that criteria is not met. What I have is below. It's not working, but I'm not sure how to fix it. Any ideas?

=IF(Dates@row <= $Dates$2, SUM([Actual Cumulative Labor]10 + [Planned Billable Labor]10), ""), IF(Dates@row > $Dates$2, SUM([Estimated at Completion]10+[Planned Billable Labor]@row), "")

Thanks!

Carly

Paul Newcome

Try this...

=IF(Dates@row <= $Dates$2, SUM([Actual Cumulative Labor]10 + [Planned Billable Labor]10), SUM([Estimated at Completion]10+[Planned Billable Labor]@row))

Paul Newcome

Try this...

=IF(Dates@row <= $Dates$2, SUM([Actual Cumulative Labor]10 + [Planned Billable Labor]10), SUM([Estimated at Completion]10+[Planned Billable Labor]@row))

carlycrisp

Thanks, Paul! That worked!

Paul Newcome

Happy to help. 👍️