Posted to microsoft.public.excel.worksheet.functions

taxmom

Posts: n/a

Fix Simple #Div/0! error

Thank you so much, I see what I was doing wrong on the IF iserror.

You are wonderful! thank you, thank you Have a great day!

"Bondi" wrote:

Hi,

Try

=if(iserror((E7+F7)/$J$12*$I$5),"",(E7+F7)/$J$12*$I$5)

Regards,
Bondi

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
Error #div/0!	Amabrow	Excel Discussion (Misc queries)	1	March 30th 06 11:00 AM
#DIV/0! Error	Kenny16301 via OfficeKB.com	Excel Discussion (Misc queries)	2	October 4th 05 03:21 AM
Simple Error Dialogue box	Rob Gould	Excel Discussion (Misc queries)	2	March 17th 05 09:13 AM
#DIV/0 ERROR in AVERAGING	Patty R.	Excel Worksheet Functions	7	March 7th 05 11:32 PM
error in simple calculation?	Tobias	Excel Discussion (Misc queries)	4	March 4th 05 01:27 PM

All times are GMT +1. The time now is 10:59 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us