IF statement to rid the sheet of "#Div/0"

Excel Help for If Statement To Rid The Sheet Of "#div/0" in Presenting and Reporting Data

If Statement To Rid The Sheet Of "#div/0"

Rate this: (3/5 from 1 vote)

	Here is my formula =SUM('Active Job Hours '!G4/'Active Job Hours '!E4)*1 How do I add an IF statement to get rid of the #DIV/0! in cells where they occur. Working with Excel 07
	Eandelin
	Posted by eandelin on 18 Nov 2008

Replies - Displaying 1 to 2 of 2

Order Replies By: Most Recent | Chronological | Highest Rated

	rid of div/0 Rate this: (3/5 from 1 vote) the formula will be try this formula =if(iserror(SUM('Active Job Hours '!G4/'Active Job Hours '!E4)*1),"",SUM('Active Job Hours '!G4/'Active Job Hours '!E4)*1)
	Posted by [email protected] on 05 Jan 2009

	Or this. Rate this: (3/5 from 1 vote) And that returns you a blank cell?  What about using that to have the cells background made a color instead of displaying the Div/0 ? -C.W. http://www.oneclickcommissions.omc/excel-statement.html
	-Conbon
	Posted by connerwalsh on 23 Apr 2011

Displaying page 1 of 1