SOLVED

If statement help-basic question

Copper Contributor

Hi all

 

this is probably a basic one, but need help!

I have a basic formula for left to spend column L, its basically I minus K to get what is left to spend

=K2-I2

 

However, if K is 0.00 id like left to spend to change to "no budget" or some sort of text

 

Brendan_Wilson_0-1693769446389.png

 

2 Replies
best response confirmed by Brendan_Wilson (Copper Contributor)
Solution

@Brendan_Wilson 

=IF(K2=0, "No Budget", K2-I2)

Thanks,,:thumbs_up: