the winnipeg sandbox
Would you like to react to this message? Create an account in a few clicks or log in to continue.
the winnipeg sandbox

Latest topics

» Gord Steeves should run for Mayor
by FlyingRat Wed Aug 13, 2014 4:58 pm

» To discontinue?
by EdWin Sat Jul 12, 2014 9:26 pm

» Sandbox breakfast get-together, Saturday, January 25, 2014.
by rosencrentz Fri Apr 11, 2014 11:27 pm

» 2013-14 Bisons/CIS Thread
by Hollywood Tue Apr 01, 2014 11:56 pm

» Katz must resign
by cobragt Mon Oct 28, 2013 5:09 pm

» Best Breakfast/Brunch
by cobragt Mon Oct 28, 2013 5:07 pm

» Manitoba Action Party
by RogerStrong Mon Oct 21, 2013 2:24 pm

» Police Respond to a silent alarm With Guns Drawn
by EdWin Tue Aug 20, 2013 10:10 pm

» Details about Cineplex SuperTicket -- interesting promotion
by MattKel Thu Jul 18, 2013 4:08 pm

» Freep locks out non-subscriber commentary
by Deank Mon Jul 08, 2013 3:58 pm

» 7-year sentence for Berlusconi
by FlyingRat Mon Jun 24, 2013 2:32 pm

» New Stadium
by grumpy old man Mon May 27, 2013 4:34 pm

» Winnipeg News Android App
by grumpy old man Mon May 27, 2013 4:33 pm

» First Post
by grumpy old man Fri May 24, 2013 2:43 pm

» The New Sals at Pembina and Stafford
by grumpy old man Thu Apr 25, 2013 1:35 pm

» Emma Watson wants to do nude scenes for 50 shades of grey movie
by FlyingRat Wed Apr 24, 2013 10:39 am

» Museum finally admits it needs to raise more money priovately.
by FlyingRat Wed Apr 24, 2013 10:32 am

» And You Thought Your Taxes Are High Now!!!
by FlyingRat Wed Apr 24, 2013 10:21 am

» free chocolate sample
by cobragt Sun Mar 31, 2013 6:12 pm

» Do you want a gift certificate for A winnipeg restraunt?
by cobragt Sun Mar 31, 2013 6:12 pm


You are not connected. Please login or register

Help writing an "if" statement...

3 posters

Go down  Message [Page 1 of 1]

1Help writing an "if" statement... Empty Help writing an "if" statement... Fri Dec 17, 2010 10:44 am

grumpy old man

grumpy old man
administrator
administrator

I have created this if statement: =IF(H52<115,115,H52)

As written the answer will always be a minimum of 115. What I need is an answer that will be minimum 115 or zero if there is no value in "H52".

To sum it up there can be three possible answers:
* the sum of cell H52 if the sum is greater than 115.
* 115 if the sum is less than 115.
* Zero if there is no value in H52.

2Help writing an "if" statement... Empty Re: Help writing an "if" statement... Fri Dec 17, 2010 10:53 am

Guest

Anonymous
Guest

Sorry I cannot help...I've moved on from "if" statements. I now concentrate soley on "butts".

3Help writing an "if" statement... Empty Re: Help writing an "if" statement... Fri Dec 17, 2010 11:55 am

AGEsAces

AGEsAces
moderator
moderator

grumpy old man wrote:I have created this if statement: =IF(H52<115,115,H52)

As written the answer will always be a minimum of 115. What I need is an answer that will be minimum 115 or zero if there is no value in "H52".

To sum it up there can be three possible answers:
* the sum of cell H52 if the sum is greater than 115.
* 115 if the sum is less than 115.
* Zero if there is no value in H52.

I find most of my Excel (I'm assuming you're using Excel) answers here:
http://www.mrexcel.com/forum/index.php

However...I'll have a go.

Try this one:
=IF(OR(A1=0,A1>115),A1,115)

http://www.photage.ca

4Help writing an "if" statement... Empty Re: Help writing an "if" statement... Fri Dec 17, 2010 12:04 pm

AGEsAces

AGEsAces
moderator
moderator

You could also try these:

=IF(H52="",0,IF(H52<115,115,H52))

=IF(H51="",0,MAX(H52,115))

http://www.photage.ca

5Help writing an "if" statement... Empty Re: Help writing an "if" statement... Fri Dec 17, 2010 12:15 pm

grumpy old man

grumpy old man
administrator
administrator

AGEsAces wrote:=IF(OR(A1=0,A1>115),A1,115)
This one worked. Thanks man!

BTW the other two did not!

6Help writing an "if" statement... Empty Re: Help writing an "if" statement... Fri Dec 17, 2010 12:21 pm

AGEsAces

AGEsAces
moderator
moderator

Good to know...
I did not write the other two...got them from that forum as suggestions from other people.

http://www.photage.ca

7Help writing an "if" statement... Empty Re: Help writing an "if" statement... Fri Dec 17, 2010 3:50 pm

Guest

Anonymous
Guest

Is there a forum on butts that you can recommend?

8Help writing an "if" statement... Empty Re: Help writing an "if" statement... Fri Dec 17, 2010 3:51 pm

Deank

Deank
contributor eminence
contributor eminence

foobies.com

9Help writing an "if" statement... Empty Re: Help writing an "if" statement... Fri Dec 17, 2010 3:54 pm

AGEsAces

AGEsAces
moderator
moderator

http://www.photage.ca

Sponsored content



Back to top  Message [Page 1 of 1]

Permissions in this forum:
You cannot reply to topics in this forum