Hi
I am wondering whether it is possible to use an IF formula to use one of two formulas depending on whether a cell is equal to 0.5 or not 0.5. I am just wondering whether this is possible because so far when I have tried it has just written the formula in the cell rather than working it out.
Thanks
Bookmarks