finding a formula

[JILLY]

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

 

[michael.a7]

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

 

[JILLY]

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