#### IF statement help #2

```Hi

What im trying to do is,
Calculate a Cell x say 0.5.  If the result is a negative number, sho
0.  If it is a positive number, work it out and show the answer.  Jus
tried, and cant seem to get it right for some reason.  I dont want t
have to use another cell for no reaon, as I need to present th
worksheet

This is what I tried, IF((E22*0.5)>0), (E22*0.5),

Thank

--
RudeYut
-----------------------------------------------------------------------
RudeYute's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3295

```
 0
3/29/2006 10:22:25 PM
excel 39879 articles. 2 followers.

3 Replies
639 Views

Similar Articles

[PageSpeed] 16

```"RudeYute" <RudeYute.25gcnm_1143671100.3118@excelforum-nospam.com> wrote in
message news:RudeYute.25gcnm_1143671100.3118@excelforum-nospam.com...
>
> Hi,
>
> What im trying to do is,
> Calculate a Cell x say 0.5.  If the result is a negative number, show
> 0.  If it is a positive number, work it out and show the answer.  Just
> tried, and cant seem to get it right for some reason.  I dont want to
> have to use another cell for no reaon, as I need to present the
> worksheet.
>
> This is what I tried, IF((E22*0.5)>0), (E22*0.5), 0
>
> Thanks
>
>
> --
> RudeYute
> ------------------------------------------------------------------------
> RudeYute's Profile:
> http://www.excelforum.com/member.php?action=getinfo&userid=32959

So close...

=IF(E22*.5>0,E22*.5,0)

Beege

```
 0
3/29/2006 10:33:56 PM
```=MAX(E22*0.5,0)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"RudeYute" <RudeYute.25gcnm_1143671100.3118@excelforum-nospam.com> wrote in
message news:RudeYute.25gcnm_1143671100.3118@excelforum-nospam.com...
>
> Hi,
>
> What im trying to do is,
> Calculate a Cell x say 0.5.  If the result is a negative number, show
> 0.  If it is a positive number, work it out and show the answer.  Just
> tried, and cant seem to get it right for some reason.  I dont want to
> have to use another cell for no reaon, as I need to present the
> worksheet.
>
> This is what I tried, IF((E22*0.5)>0), (E22*0.5), 0
>
> Thanks
>
>
> --
> RudeYute
> ------------------------------------------------------------------------
> RudeYute's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=32959
>

```
 0
bob.phillips1 (6510)
3/29/2006 10:46:53 PM
```Beege Wrote:
> "RudeYute" <RudeYute.25gcnm_1143671100.3118@excelforum-nospam.com> wrot
> in
> message news:RudeYute.25gcnm_1143671100.3118@excelforum-nospam.com...
> >
> > Hi,
> >
> > What im trying to do is,
> > Calculate a Cell x say 0.5.  If the result is a negative number
> show
> > 0.  If it is a positive number, work it out and show the answer.
> Just
> > tried, and cant seem to get it right for some reason.  I dont wan
> to
> > have to use another cell for no reaon, as I need to present the
> > worksheet.
> >
> > This is what I tried, IF((E22*0.5)>0), (E22*0.5), 0
> >
> > Thanks
> >
> >
> > --
> > RudeYute
>
> ------------------------------------------------------------------------
> > RudeYute's Profile:
> > http://www.excelforum.com/member.php?action=getinfo&userid=32959
> > View this thread
>
>
> So close...
>
> =IF(E22*.5>0,E22*.5,0)
>
> Beege
Perfect, thanks

--
RudeYut
-----------------------------------------------------------------------
RudeYute's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3295

```
 0
3/29/2006 10:54:22 PM

Similar Artilces:

Problems printing in Publisher 2003 with HP PSC 2410 #2
I am new to publisher 2003 and am having great difficulties printing anything properly using an HP PSC 2410 all in one. As an example when trying to print a half page side folded pre-designed greetings card all that prints is page 1 and part of page 4, minus any text. Pages 2 and 3 are missing altogether. The print preview however displays everything correctly. I have reinstalled Office 2003 and updated the printer drivers to the latest versions but the problem remains. Any help is much appreciated. ...

Macro help #12
Hi, I am working on a macro in Excel 2003 Pro, and everytime I go to sort a column of data. There are about 10 rows of data in about 200+ columns. I can only get the macro to sort the column that I edited it with. How can I create the macro, so each time I click on the first row of each column, click the macro button I will assign to the toolbar, then that row will be sorted, and do this for each column? Any help at all would be greatly appreciated, Jeff Garrett (user_jeff@hotmail.com) Hi Jeff please post your current code and then we can suggest changes to it. Cheers JulieD "...

Upgrading from Money 2002 #2
I have the original money 2002 that came with the computer and have never upgraded. Which is the best version to go to? More importantly, when I purchase and download the upgrade, will it go over the current program and update all the information that I currently have? Thanks and Happy New Year -- mfletcher The latest version in the US is Money+ aka Money 2008. Other geographies have different versions. Money keeps all your data in the .mny file not the program. When you install the new version it usually remembers where your .mny file was, makes a copy of it (for safety) and then up...

How do I prevent "Help" from opening when I open Excel?
Whenever I open Excel 2003 the Help feature opens on the right. How do I pevent this? I only want Excel to open with a new sheet. -- Lee P Lee Help or TaskPane. For Help, you should be able to close it using the "x" and next time open Excel should not display. If TaskPane, go to Tools>Options>View and uncheck "Startup Task Pane" Gord Dibben Excel MVP On Mon, 12 Dec 2005 13:05:29 -0800, "Lee P" <LeeP@discussions.microsoft.com> wrote: >Whenever I open Excel 2003 the Help feature opens on the right. >How do I pevent this? I only want Exce...

pantone colors #2
Is there a way to make Publisher 2007 show all Pantone Colors? I want 021 U. Find doesn't do it. B I don't think Publisher has all the Pantone colors. There are close equivalents. Not the same of course... C=0 M=53 Y=100 K=0 R=252 G=115 B=35 -- Mary Sauer http://msauer.mvps.org/ "Bob Wright" <mmpdallas@sbcglobal.net> wrote in message news:%23N1wilmHJHA.1364@TK2MSFTNGP04.phx.gbl... > Is there a way to make Publisher 2007 show all Pantone Colors? I want 021 U. > Find doesn't do it. > B Guess you are right, not all there. Weird. Close equivalents ...

Formulas don't work in certain cells #2
nope, the cells are formatted as numbers. I simply cannot figure thi out. -Jorda -- kalik24 ----------------------------------------------------------------------- kalik247's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1594 View this thread: http://www.excelforum.com/showthread.php?threadid=27423 Being formatted as numbers doesn't automatically mean they are numbers. Copy an empty cell formatted to General. Select your range of numbers and Paste Special>Add>OK>Esc Gord Dibben Excel MVP On Mon, 1 Nov 2004 11:59:46 -0600, kalik247 <kalik2...

Print Macro #2
Trying to write a macro to print a spreadsheet where the number of rows of data varies. What's wrong with this code? Dim rng As Range Set rng = Range("A1").End(xlDown).End(xlToRight) With ActiveSheet.PageSetup .PrintArea = rng End With Thank you. Pam Hi Pam Leave your PrintArea empty Excel will print all cells with a value on the sheet -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Pam" <gasp0225@juno.com> wrote in message news:16e401c38521\$a7d25420\$3501280a@phx.gbl... > Trying to write a macro to ...

Date Range Formula Question
Hello, I'm having trouble with a formula and I'm hoping someone can help. :confused: Sample Data Includes the following: Pay Period Start Pay Period End Pay Period # 12/16/01 12/29/01 26 12/30/01 01/12/02 25 01/13/01 01/26/02 24 01/27/02 02/09/02 23 02/10/02 02/23/02 22 The pay periods continue until there are 26 pay periods for the entire year....

Importing data into Outlook #2
Is there a process or program with which I can transfer my ACT! data into Outlook contacts? Thanks! ...

Unable to send a message, its been trying for 24hrs #2
I have been tring to send an email that contains a photo, for the past 24hrs. it wont send. all I am able to see is "cannot open this file, Outlook has already begun transmission. It wont even let me delete the message http://www.howto-outlook.com/faq/messagestuckinoutbox.htm=20 --=81 Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. All unsolicited mail sent to my personal account will be deleted without reading. =20 After furious head scratching, tillybird asked: | I have been tring to send an email that contains a photo, for the | past ...

HELP!!! 08-30-03
please elp me. my mom is a medical transcriber and she has a dictionary she uses through windows 98. and her comp has no memory, so we need to update her operating system inoder to put more memory on there. she needs her dictionary and i was wandering how to access it and if possible how to save it on to a cd. thank you for ur time Dear jason you have to have a dictornary corect i have one i could email you if you like just email me back i mean i use this dictornary really well and it works for 95-Xp so if you want give me a hollar ok peace out danny "jason" <jasonr_206@hotm...

help with installation isue
Hope this is correct NG When I try to run `Karens replicator` (for external backup) My PC automatically runs an installation for publisher 2003 and then gives error message........... Istallation error require file SKU019.CAB then asks for original CD to be inserted. Publisher still works ok I can`t see what the relationship between the 2 are, how do I stop this trying to install? thanks -- Rent a villa in Turkey http://www.freewebs.com/turkeyrent/ I would suggest aksing the folks over at karenware.com. http://www.karenware.com/powertools/troubl...

The Help menu is not available in the Employee file screen. Also there is not at this time any french version help menu available with HR. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/de...

Microsoft CRM 1.2 database export failed 01-27-06
I am receiving this message when I try to upgrade my CRM 1.2 to CRM 3.0, does any one have any idea what this means? ...

Barcodes Code
I am trying to print a barcode in the 128 code. Though it seems the public domain/GPL ones of the truetype do not print a scanable barcode. Is there any suggestions... Or if anyone can point me into the right direction on how to do this or point me in direction of one that will work with access or excel 2000 or 2003. Much appreciated. Or help me figure out WHY it isnt producing a readable one in 128.. Hi Lester, Perhaps the problem is with the resolution on your printer. Try printing the barcode larger. Perhaps even turn off print to fit under print, page setup. --- HTH, David McRi...

Ad Hoc Reporting #2
Hi, I am putting together an ad hoc report in Excel. My query is in the VB editor. I am trying to specify criteria Select x,y,z where... in the WHERE, I am struggling. I want to take a range of ids specified in the worksheet, F2:F55. So Select x, y, z where IDs IN ( F2:F55 ) I tried to use WHERE IN ( Range(F2:F55) ) but it did not like it. What syntax should I use to make this work? Thanks! ...

Reinstall #2
I am reinstalling Office 2003 on a new computer. I have installed the software but I the contact information and calendars, messages, notes etc have not transferred to the new one. How can I do that? ...

GetTextExtentPoint32 #2
Hi, I have multiple problems here :( I have a short text in UNICODE and the text contains newlines as well (carriage return and newline) and it seems that GetTextExtentPoint32 doesn't take into account the newlines. So I broke the lines myself and checked which has the longest length. Also, for the "int cbString" parameter, if my text is "hello" and I pass 5, then it doesn't return the current width. I have to send 6. Yes, I do select my font in the HDC before calling this. Other problem! Interline spacing issue Lines are separated by a certain mount of pixels...

Incoming Emails #2
Do I always have to click the "Send/Receive" button in order to get my new emails? No, you can go to TOOLS, then SEND/RECEIVE SETTINGS and then DEFINE SEND/RECEIVE SETTINGS and in the box's shown, you can tell Outlook to automatically send or receive your messages every XX mins. Tedd -- Tedd Riggs PDASquare Content Developer www.pdasquire.com "wj" <anonymous@discussions.microsoft.com> wrote in message news:88174331-72B4-4ECF-B688-DF745D9178EF@microsoft.com... > Do I always have to click the "Send/Receive" button in order to get my new emails? T...

This is a multi-part message in MIME format. ------=_NextPart_000_0016_01C6D1D3.B9AB1720 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I'm having this error message. Event Type: Error Event Source: MSExchangeAL Event Category: Service Control=20 Event ID: 8231 Date: 9/6/2006 Time: 4:39:10 PM User: N/A Computer: MAIL Description: Permanent failure reported by policy group provider for 'CN=3DSystem = Policies,CN=3DDOMAIN,CN=3DMicrosoft = Exchange,CN=3DServices,CN=3DConfiguration,DC=3DDOMAIN,DC=3Dcom':'MAD.EXE'= ,...

Re:Help with verifying the signature of enveloped -message using x509 certificates.
Re:Help with verifying the signature of enveloped -message using x509 certificates. Hey Friends, I have an xml given by our partner trying to integrating with us and i have their certificate with public key installed in both personal and trusted people folders. when i am using the following code to check the signature of message signed by my certificate i am able to verify the signature but when i am trying to check the signature of the message of our partner using the same following code i am not able to verify the message. the message sent by our partner is right below the code.I wou...

outlook client problem #2
Hi I have a one user that have problem with outlook client are always prompt to login outlook 2007 crmclient V3C and have all patch install You might want to create a new profile for that client. Also check that they are running SQL 2005 Express on their desktop as opposed to an MSDE instance. Their was a shift in databases from 2000 to 2005 during the life of CRM v3.0 "sjm" wrote: > Hi > I have a one user that have problem with outlook client are always prompt to > login > outlook 2007 > crmclient V3C and have all patch install Hi sjm, Is the user also prom...

CTreeView #2
I use TVS_SHOWSELALWAYS style with the tree control. When the focus from the view is lost, the selection bar turns pale grey. Is there a way I could change the color of selection bar? Thanks in advance You may be able to use OnCustomDraw() to do this sort of thing. http://www.pocketpcdn.com/articles/tree_color.html http://cvs.sourceforge.net/viewcvs.py/shareaza/shareaza/CtrlSharedFolder.cpp?rev=1.3 http://www.codeguru.com/Cpp/controls/treeview/newlistviewcontrolie40/article.php/c711/ Tom "RG" <nobody@nowhere.com> wrote in message news:eZSucQKrFHA.3264@TK2MSFTNGP12...