Help with formula

Vinton Douglas

Good day,

Can an exclusion be inserted in the below formula such that if the answer turns out to be zero or negative value, the cell remains blank?

=[Duration to Transport and Return]@row * $Column$1

Andrée Starå

Hi @Vinton Douglas

I hope you're well and safe!

Try something like this.

=IF([Duration to Transport and Return]@row * $Column$1 <= 0, "", 
[Duration to Transport and Return]@row * $Column$1)

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Vinton Douglas

I hope you're well and safe!

Try something like this.

=IF([Duration to Transport and Return]@row * $Column$1 <= 0, "", 
[Duration to Transport and Return]@row * $Column$1)

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Vinton Douglas

Thanks much. Works great!

Andrée Starå

@Vinton Douglas

Excellent!

You're more than welcome!