Can someone please help me

[stevenmorrison]

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.

[Ian]

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"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Bob Phillips]

=IF(A1=5014,L1-M1,"")

etc.

Is that it?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"stevenmorrison"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Ian]

"Bob Phillips" <[email protected]> wrote in message
news:ep%[email protected]...
> =IF(A1=5014,L1-M1,"")

Which is exactly the response I gave to the OP in another group :-)

[Ian]

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"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Bob Phillips]

=IF(A1=5014,L1-M1,"")

etc.

Is that it?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"stevenmorrison"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Ian]

"Bob Phillips" <[email protected]> wrote in message
news:ep%[email protected]...
> =IF(A1=5014,L1-M1,"")

Which is exactly the response I gave to the OP in another group :-)

[Bob Phillips]

=IF(A1=5014,L1-M1,"")

etc.

Is that it?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"stevenmorrison"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Ian]

"Bob Phillips" <[email protected]> wrote in message
news:ep%[email protected]...
> =IF(A1=5014,L1-M1,"")

Which is exactly the response I gave to the OP in another group :-)

[Ian]

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"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Ian]

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"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Bob Phillips]

=IF(A1=5014,L1-M1,"")

etc.

Is that it?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"stevenmorrison"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Ian]

"Bob Phillips" <[email protected]> wrote in message
news:ep%[email protected]...
> =IF(A1=5014,L1-M1,"")

Which is exactly the response I gave to the OP in another group :-)

[Ian]

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"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Ian]

"Bob Phillips" <[email protected]> wrote in message
news:ep%[email protected]...
> =IF(A1=5014,L1-M1,"")

Which is exactly the response I gave to the OP in another group :-)

[Bob Phillips]

=IF(A1=5014,L1-M1,"")

etc.

Is that it?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"stevenmorrison"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Bob Phillips]

=IF(A1=5014,L1-M1,"")

etc.

Is that it?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"stevenmorrison"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Ian]

"Bob Phillips" <[email protected]> wrote in message
news:ep%[email protected]...
> =IF(A1=5014,L1-M1,"")

Which is exactly the response I gave to the OP in another group :-)

[Ian]

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"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Ian]

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"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Bob Phillips]

=IF(A1=5014,L1-M1,"")

etc.

Is that it?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"stevenmorrison"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Ian]

"Bob Phillips" <[email protected]> wrote in message
news:ep%[email protected]...
> =IF(A1=5014,L1-M1,"")

Which is exactly the response I gave to the OP in another group :-)

[Ian]

"Bob Phillips" <[email protected]> wrote in message
news:ep%[email protected]...
> =IF(A1=5014,L1-M1,"")

Which is exactly the response I gave to the OP in another group :-)

[Bob Phillips]

=IF(A1=5014,L1-M1,"")

etc.

Is that it?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"stevenmorrison"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Ian]

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"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Ian]

"Bob Phillips" <[email protected]> wrote in message
news:ep%[email protected]...
> =IF(A1=5014,L1-M1,"")

Which is exactly the response I gave to the OP in another group :-)

[Bob Phillips]

=IF(A1=5014,L1-M1,"")

etc.

Is that it?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"stevenmorrison"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Ian]

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"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Bob Phillips]

=IF(A1=5014,L1-M1,"")

etc.

Is that it?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"stevenmorrison"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Ian]

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"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Ian]

"Bob Phillips" <[email protected]> wrote in message
news:ep%[email protected]...
> =IF(A1=5014,L1-M1,"")

Which is exactly the response I gave to the OP in another group :-)

[Ian]

"Bob Phillips" <[email protected]> wrote in message
news:ep%[email protected]...
> =IF(A1=5014,L1-M1,"")

Which is exactly the response I gave to the OP in another group :-)

[Bob Phillips]

=IF(A1=5014,L1-M1,"")

etc.

Is that it?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"stevenmorrison"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Ian]

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"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Ian]

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"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Ian]

"Bob Phillips" <[email protected]> wrote in message
news:ep%[email protected]...
> =IF(A1=5014,L1-M1,"")

Which is exactly the response I gave to the OP in another group :-)

[Bob Phillips]

=IF(A1=5014,L1-M1,"")

etc.

Is that it?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"stevenmorrison"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Ian]

"Bob Phillips" <[email protected]> wrote in message
news:ep%[email protected]...
> =IF(A1=5014,L1-M1,"")

Which is exactly the response I gave to the OP in another group :-)

[Bob Phillips]

=IF(A1=5014,L1-M1,"")

etc.

Is that it?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"stevenmorrison"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Ian]

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"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Ian]

"Bob Phillips" <[email protected]> wrote in message
news:ep%[email protected]...
> =IF(A1=5014,L1-M1,"")

Which is exactly the response I gave to the OP in another group :-)

[Ian]

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"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Bob Phillips]

=IF(A1=5014,L1-M1,"")

etc.

Is that it?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"stevenmorrison"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Ian]

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"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Bob Phillips]

=IF(A1=5014,L1-M1,"")

etc.

Is that it?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"stevenmorrison"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Ian]

"Bob Phillips" <[email protected]> wrote in message
news:ep%[email protected]...
> =IF(A1=5014,L1-M1,"")

Which is exactly the response I gave to the OP in another group :-)

[Ian]

"Bob Phillips" <[email protected]> wrote in message
news:ep%[email protected]...
> =IF(A1=5014,L1-M1,"")

Which is exactly the response I gave to the OP in another group :-)

[Ian]

"Bob Phillips" <[email protected]> wrote in message
news:ep%[email protected]...
> =IF(A1=5014,L1-M1,"")

Which is exactly the response I gave to the OP in another group :-)

[Bob Phillips]

=IF(A1=5014,L1-M1,"")

etc.

Is that it?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"stevenmorrison"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Ian]

"Bob Phillips" <[email protected]> wrote in message
news:ep%[email protected]...
> =IF(A1=5014,L1-M1,"")

Which is exactly the response I gave to the OP in another group :-)

[Ian]

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"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Ian]

"Bob Phillips" <[email protected]> wrote in message
news:ep%[email protected]...
> =IF(A1=5014,L1-M1,"")

Which is exactly the response I gave to the OP in another group :-)

[Bob Phillips]

=IF(A1=5014,L1-M1,"")

etc.

Is that it?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"stevenmorrison"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Ian]

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"
<[email protected]> wrote in
message news:[email protected]...
>
> 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
>