Formula If Blank

Platform discussions Special workflows & use cases
1
  1. See attached photo, is it possible the formula results should only be generate if the “current balance” cell is entered?
  2. Can I get the $ symbol in the formula cell?

Capture
Capture766×229 17.5 KB

2

@Yidi

  1. Yes.
  2. Yes.

IF({Current Balance},TEXT({Original Balance}-{Current Balance},"$#,##0"),"")

Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: Creating subitems using Make/Integromat The Monday Man (EASY) Way
Contact me directly here: Contact – The Monday Man

3

Thanks @JCorrell for your reply, unfortunately the “amount saved” cell is not empty even when the “Current balance” cell is blank.
See attached.

Capture2
Capture2933×273 26.9 KB

4

@Yidi

My Badness.

Try this…
IF({Current Balance}<>"0",TEXT({Original Balance}-{Current Balance},"$#,##0"),"")

Note- {Current Balance}<>"0" will return false ONLY when {Current Balance} is blank; if the cell value is set to 0, {Current Balance}<>"0" will return false.

1 Like
5

You rock @JCorrell :+1::+1:
One follow up question: how would i do % ?
“TPZ fee” should be 10% of the “Amount Saved”
Capture3

6

@Yidi

IF({Current Balance} <> "0", 
   TEXT(({Original Balance} - {Current Balance}) * 0.10, "$#,##0"), 
"")

Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: Creating subitems using Make/Integromat The Monday Man (EASY) Way
Contact me directly here: Contact – The Monday Man

7

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.