Can I get help on this formula? Not sure where I am getting it wrong.

Stacy Stoffel · 04/12/22

I need this formula to be one value if Yes and the other Value if not Yes:

Leibel S · 04/12/22

Does not seem like you need the OR function in there.

=IF([After Hours]@row="Yes", [Total Hours]@row * 375, [Total Hours]@row * 250)

Stacy Stoffel · 04/12/22

I tried that too and got the "unparseable" error.

Leibel S · 04/12/22

Typo, see your column has a question mark at the end...

=IF([After Hours?]@row = "Yes", [Total Hours]@row * 375, [Total Hours]@row * 250)

Stacy Stoffel · 04/12/22

great thank you! I had tried it so many times, that I missed that question mark. Appreciate the second set of eyes :)

Answers