Forums

General Betting

Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
Scottymadras1
02 Mar 10 21:13
Joined:
Date Joined: 29 Jun 09
| Topic/replies: 36 | Blogger: Scottymadras1's blog
I am real newbie to excel and with some help already from Lenze I am starting to master some of the basics!

What I am trying to achieve now is this -

If I insert the letter W into cell A1 it populates cell A4 with whatever figure is in A2 and if I insert L into A1 it populates cell A4 with whatever figure is in A3.

Hope that makes sense !

Regards

Scott
Show More
Loading...
Report Ghetto Joe March 2, 2010 9:26 PM GMT
=IF(A1="W",A2,IF(A1="L",A3,""))
Report Ivor March 2, 2010 9:37 PM GMT
Well did Ghetto - beat me by seconds :(
Report Scottymadras1 March 2, 2010 9:40 PM GMT
Thankyou !
Post Your Reply
<CTRL+Enter> to submit
Please login to post a reply.

Wonder

Instance ID: 13539
www.betfair.com