Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 1

HELP please... easy function

Hi,
I have a problem.
Here is the main formula:
=(A5*B5)/C5
but if there is nothing( blank) in cells A5 and C5 i got #DIV/0!
I don't want to have this error #DIV/0!, i just want that IF cells A5
and C5 are blank result 0 (ZERO).

I tried with that formula but is not working:

=IF(A5="blank";0;(A5*B5)/C5)

Can anyone help me please?

Thanks a lot

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
easy function quesiton	Dylan @ UAFC[_2_]	Excel Worksheet Functions	2	January 20th 09 07:28 PM
Easy IF Function	pau1a via OfficeKB.com	Excel Discussion (Misc queries)	1	March 24th 06 01:36 AM
Sum function question - easy?	Ian in Ankara	Excel Worksheet Functions	6	February 13th 06 05:16 PM
Function question (probably easy)	Dahlman	Excel Discussion (Misc queries)	4	April 4th 05 03:09 PM
Easy function question	Dahlman	Excel Discussion (Misc queries)	2	March 31st 05 12:35 AM

All times are GMT +1. The time now is 08:01 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us