I have cell K9 that has a balance 200 in it, when I put money towards it will eventually go down to 0. When it gets to 0.00 I want the cell next to it(J9) to say "Fully funded". Any ideas on how I can do that?
Thanks
I have cell K9 that has a balance 200 in it, when I put money towards it will eventually go down to 0. When it gets to 0.00 I want the cell next to it(J9) to say "Fully funded". Any ideas on how I can do that?
Thanks
Do you mean...
=IF(K9=0,"Fully Funded","")
or
=IF(ROUND(K9,2)=0,"Fully Funded","")
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
The top one Worked, Thanks a bunch. =)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks