software

Hard for me to explain.

If i enter the word cash in A1, the amount of cash in B1 eg £100.00, i
also want the same amount of cash listed in F1, how do i do a formula
to recognize that when the word cash is displayed in a column, i want
F1 to copy the cell of B1 which is the amount of cash.

Please help anyone--
JILLY
------------------------------------------------------------------------
JILLY's Profile: www.excelforum.com/member.php...oamp;userid=33008
View this thread: www.excelforum.com/showthread...hreadid=528859
Hi Jilly,

So if you have Cash in A1 and £100.00 in B1 Then type
=IF(A1=quot;Cashquot;,B1,quot;quot;) in cell F1Regards,
Michael
www.excelexchange.com--
michael.a7
------------------------------------------------------------------------
michael.a7's Profile: www.excelforum.com/member.php...oamp;userid=33027
View this thread: www.excelforum.com/showthread...hreadid=528859
Am i an idiot or what now that you have explained it, it iss so simple
Thanks a lot
Jilly--
JILLY
------------------------------------------------------------------------
JILLY's Profile: www.excelforum.com/member.php...oamp;userid=33008
View this thread: www.excelforum.com/showthread...hreadid=528859