Cell not showing empty instead showing False

Hi,

Thanks for looking at the post.

I have below formula in the VBA and I have copy of the same formula in the next 100 rows respectively.

The issue is when I put if the cell is empty then "" , I am getting an error. Currently all cells which don't have value is showing as False. Any idea of where I am going wrong please. I wanted to see empty cell if the value is not there please.

Thanks for any help

Please Login or Register  to view this content.

This looks like VBA. Shall I move the thread for you?

Maybe this:

=IF(F6="","",IF(F6<=$G$1,SUMIFS($D$2:$D$100,$E$2:$E$100,F6))

No worries.

You may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.