Hi,
I'm developing a productivity app within Excel, and what I would like to do is have a happy face show up in the right adjacent cell whenever you type in an accomplishment.
I'm pretty sure this can be accomplished with an IF formula, but I'm not familiar enough with the syntax.
So I need the IF formula to do this: If there is any data in the "accomplishment entry cell" (D5), then something like: IF(D5>0) then (E5=E4)
Any help would be greatly appreciated!
Thanks,
Bryan
PS I've attached a file
Bookmarks