finding a formula
 

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: http://www.excelforum.com/member.php...o&userid=33008
View this thread: http://www.excelforum.com/showthread...hreadid=528859

finding a formula
 

Hi Jilly,

So if you have Cash in A1 and £100.00 in B1 Then type
=IF(A1="Cash",B1,"") in cell F1


Regards,
Michael
http://www.excelexchange.com


--
michael.a7
------------------------------------------------------------------------
michael.a7's Profile: http://www.excelforum.com/member.php...o&userid=33027
View this thread: http://www.excelforum.com/showthread...hreadid=528859

finding a formula
 

Am i an idiot or what now that you have explained it, it iss so simple
Thanks a lot
Jilly


--
JILLY
------------------------------------------------------------------------
JILLY's Profile: http://www.excelforum.com/member.php...o&userid=33008
View this thread: http://www.excelforum.com/showthread...hreadid=528859