Hi,
wondered if someone can give me a bit of help.
I have 4 columns, A, B, C, and D.
In column A I numeric value (£1500.00 for example)
In column B I want to either put Yes or No
If I have put Yes in column B, I want column A's figure to appear in column C.
If I have put a No in column B, I want column A's figure to appear in column D.
________
No doubt this is a simple calculation, any help would bee much appreciated.
Many Thanks,
Mark
Bookmarks