Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can someone please help me
im not the best at my formulaes when it comes to excel, im on a trial period for a I.T company and ive been asked to come up with a formule. heres my problem, 2 different values in collum a,5014 & 5015, now basic formula is if cell A = 5014. L-M. so the L & M rows which have 5014 in thier row are used in this calculation, can someone please help me. as im under a lot of pressure. -- stevenmorrison ------------------------------------------------------------------------ stevenmorrison's Profile: http://www.excelforum.com/member.php...o&userid=26188 View this thread: http://www.excelforum.com/showthread...hreadid=394973 |
#2
|
|||
|
|||
Please don't post the same message in multiple groups. You'll find that most
people here read them all and it gets annoying. See my reply in microsoft.public.excel. -- Ian -- "stevenmorrison" <stevenmorrison.1tluz9_1123773028.7784@excelforu m-nospam.com wrote in message news:stevenmorrison.1tluz9_1123773028.7784@excelfo rum-nospam.com... im not the best at my formulaes when it comes to excel, im on a trial period for a I.T company and ive been asked to come up with a formule. heres my problem, 2 different values in collum a,5014 & 5015, now basic formula is if cell A = 5014. L-M. so the L & M rows which have 5014 in thier row are used in this calculation, can someone please help me. as im under a lot of pressure. -- stevenmorrison ------------------------------------------------------------------------ stevenmorrison's Profile: http://www.excelforum.com/member.php...o&userid=26188 View this thread: http://www.excelforum.com/showthread...hreadid=394973 |
#3
|
|||
|
|||
=IF(A1=5014,L1-M1,"")
etc. Is that it? -- HTH RP (remove nothere from the email address if mailing direct) "stevenmorrison" <stevenmorrison.1tluz9_1123773028.7784@excelforu m-nospam.com wrote in message news:stevenmorrison.1tluz9_1123773028.7784@excelfo rum-nospam.com... im not the best at my formulaes when it comes to excel, im on a trial period for a I.T company and ive been asked to come up with a formule. heres my problem, 2 different values in collum a,5014 & 5015, now basic formula is if cell A = 5014. L-M. so the L & M rows which have 5014 in thier row are used in this calculation, can someone please help me. as im under a lot of pressure. -- stevenmorrison ------------------------------------------------------------------------ stevenmorrison's Profile: http://www.excelforum.com/member.php...o&userid=26188 View this thread: http://www.excelforum.com/showthread...hreadid=394973 |
#4
|
|||
|
|||
"Bob Phillips" wrote in message
... =IF(A1=5014,L1-M1,"") Which is exactly the response I gave to the OP in another group :-) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|