IF function

Copper Contributor

hi guys, i want to display an IF function without it showing unless i enter "yes" or "no" in the future. as you can see from G8:G22, you can see the "unpaid".  how would i have it so it is just a blank space unless i enter "yes" or "no"? thanks allScreenshot 2021-06-11 at 19.07.28.png

1 Reply

@blakesjones 

Let's say G8 contains

 

=someformula

 

Change this to

 

=IF(F8="","",someformula)

 

Fill down.