115KC
0
Follow
0
View

How to leave cell blank if cell is blank?

How will I leave my cell blank if I have this formula?

=if(O2<>"",roundup(O2-E2,0),"")

Thank you

How to leave cell blank if cell is blank?
复制链接 新浪微博 腾讯空间
微信扫一扫

0 Answer

Sort by default
Sort by hot
du7775
du7775 注册会员
2023-01-24 23:41

try:

=IF(ISBLANK(O2),,ROUNDUP(O2-E2, 0))
复制链接 新浪微博 腾讯空间
微信扫一扫

About the Author

fenglovemilly 注册会员

这家伙很懒，什么都没留下...

0
Answer
0
Article
0
Question

Question Info

Publish Time
2023-01-24 23:41
Update Time
2023-01-24 23:41

Related Question

如何避免持久化一个临时条件变量时，MassTransit automatonyis使用实体框架

关于editor md的问题

请教:TortoiseGit不能成功push项目到github是什么原因

contourarea面积计算问题

关于constructor函数的定义

Exception: Service invoked too many times for one day: gmail Don't know what quota I am reaching or how?

Azure Postgres autovacuum和分析阈值-如何改变它?

ionic开发的苹果应用上架后获取错误的hms 推送token 上架前工作正常

如何压缩3个IF循环与toggle()方法在香草Javascript?

ProseMirror / Tiptap:如何ScrollIntoView没有焦点?

115KC © 2023 闽ICP备2020022241号