Hi,
I want to write a IF statement as follows-
=IF($H$4='Current Round '!$B$3,$A5," ")
My requirement is that when the above condition fails i.e. when condition is FALSE, the outcome should be nothing so that whatever value the cell had earlier, remains in it. To further clarify,
if condition is TRUE, value of current cell = value in cell A$5.
When condition is FALSE, value of current cell (e.g. 10) = the existing value of current cell (i.e. 10)
Please help.
Thanks and Regards,
Bookmarks