Hi
I'm a novice VB user. I've written the following formula which I now realise is wrong.
=IF(F5=1,"E5",0)
What I want it to do is return the contents of cell E5 if there is a 1 in cell E6, or return 0 if there is not a 1 in cell F5. But the way I've written it I get E5 or 0.
Would really appreciate some help!
