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


--
Muppet
------------------------------------------------------------------------
Muppet's Profile: http://www.excelforum.com/member.php...o&userid=10989
View this thread: http://www.excelforum.com/showthread...hreadid=381305