To all Excel guru's
#1
Scooby Regular
Thread Starter
Join Date: Aug 2001
Location: The Sunshine State !!!
Posts: 1,222
Likes: 0
Received 0 Likes
on
0 Posts
To all Excel guru's
I am trying to put a formula together using share ranges eg
if x(a number) is greater than (y) but less than (z) then calculate this or nothing
I cannot figure out how to do this anyone help
if x(a number) is greater than (y) but less than (z) then calculate this or nothing
I cannot figure out how to do this anyone help
#2
Scooby Regular
Join Date: Jun 2003
Location: a very nice man :-) with one Fairy Token
Posts: 2,203
Likes: 0
Received 0 Likes
on
0 Posts
Originally Posted by Scooby Roo
I am trying to put a formula together using share ranges eg
if x(a number) is greater than (y) but less than (z) then calculate this or nothing
I cannot figure out how to do this anyone help
if x(a number) is greater than (y) but less than (z) then calculate this or nothing
I cannot figure out how to do this anyone help
=IF(AND(A1>B1,A1<B2),C1*D1,0)
A1, B1 etc are cell references so in your example A1 is 'x', B1 is 'y', B2 is 'z'. C1*D1 is just an example calculation if x>y & x<z. If that is not the case, zero is returned. If you put this in cell E1 for example, you would see either C1*D1 or zero, depending on what is in A1, B1, B2....
HTH
Probably a better solution to come though
#3
Scooby Regular
Thread Starter
Join Date: Aug 2001
Location: The Sunshine State !!!
Posts: 1,222
Likes: 0
Received 0 Likes
on
0 Posts
Excellent this one works a treat cheers made me a happy chappy today
Thanks again, been sat pondering this one for hours.
Thick monkey me
Thanks again, been sat pondering this one for hours.
Thick monkey me
#4
Scooby Regular
Join Date: Jun 2003
Location: a very nice man :-) with one Fairy Token
Posts: 2,203
Likes: 0
Received 0 Likes
on
0 Posts
Originally Posted by Scooby Roo
Excellent this one works a treat cheers made me a happy chappy today
Thanks again, been sat pondering this one for hours.
Thick monkey me
Thanks again, been sat pondering this one for hours.
Thick monkey me
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM
bluebullet29
General Technical
9
05 October 2015 02:17 PM