Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2006

Tip: Looking for answers? Try searching our database.

Help with IF formula

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jim - 05 Jul 2006 16:39 GMT
Hi everyone. Someone on here always has an answer for my question, so thanks
in advance.

I am running XP Pro SP2, and Office Pro 2003.

Column A is for quantity, and the quantity can be positive or negative.

Column H is for individual pricing, and Column I is for the price extension
(i.e. A*H).

Column I is blank unless there is a number to be displayed.

I have the following formula set up in I4 now:

=IF(A4>0,A4*H4,"")

which works OK if A4 is a positive number. What should the formula be so it
also works with a negative number? Rember that if A4 is blank, then I4 is
also blank.

In other words, I need an operator that will only work if A4 is not blank.

Thanks for your help.
Signature

Jim

msnews.microsoft.com - 05 Jul 2006 16:49 GMT
Try:
=IF(A4="","",A4*H4)

Is this too obvoius?

--
AP

> Hi everyone. Someone on here always has an answer for my question, so
> thanks
[quoted text clipped - 22 lines]
>
> Thanks for your help.
SteveW - 05 Jul 2006 16:51 GMT
try
=if(a4<>"",a4*h4,"")

Steve

> Hi everyone. Someone on here always has an answer for my question, so  
> thanks
[quoted text clipped - 23 lines]
>
> Thanks for your help.
mattjenkins - 05 Jul 2006 16:53 GMT
how about

=IF(A4="","",A4*H4)
flummi - 05 Jul 2006 16:55 GMT
Hi,

=IF(ISNUMBER(A4);A4*H4);"")

Hans

Jim schrieb:

> Hi everyone. Someone on here always has an answer for my question, so thanks
> in advance.
[quoted text clipped - 19 lines]
>
> Thanks for your help.
Roger Govier - 06 Jul 2006 17:46 GMT
Hi Jim

In addition to the other replies you have received, you could just use
the formula without any IF() statement, and use
Tools>Options>General>untick Zero values
to prevent anything displayed if the result is 0

Signature

Regards

Roger Govier

> Hi everyone. Someone on here always has an answer for my question, so
> thanks
[quoted text clipped - 25 lines]
>
> Thanks for your help.
SteveW - 07 Jul 2006 17:09 GMT
> Hi Jim
>
> In addition to the other replies you have received, you could just use
> the formula without any IF() statement, and use
> Tools>Options>General>untick Zero values
> to prevent anything displayed if the result is 0

Too general, imo, but custom format of #;-#; changes 0 to nothing for  
specific cells

Signature

Steve (3)

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.