Where to add the iserror statement in formula?

[redneckopen]

I have a few formulas that I need to eliminate the #DIV?0 message and for the life of me I cannot get the thing to work. I've looked at the old messages and nothing has sunk in. Help please.

=IF(M8>P8,M8-(L8/2),P8-(O8/2))

=IF(M8>P8,L8/2,O8/2)

=(F8*$D$3)/(D8+E8)

Thank you in advance.

 

[VoG]

Example

IF(ISERROR((F8*$D$3)/(D8+E8)),"",(F8*$D$3)/(D8+E8))

 

[redneckopen]

I get an error message with this?

=IF(ISERROR((M8>P8,M8-(L8/2),P8-(O8/2)),"",(m8>p8,m8-(l8/2),p8-(o8/2))

 

[Aladin Akyurek]

I have a few formulas that I need to eliminate the #DIV?0 message and for the life of me I cannot get the thing to work. I've looked at the old messages and nothing has sunk in. Help please.

=IF(M8>P8,M8-(L8/2),P8-(O8/2))

=IF(M8>P8,L8/2,O8/2)

=(F8*$D$3)/(D8+E8)

Thank you in advance.

The first formula should not return #DIV/0!. If it does, then there is already at least one #DIV/0! in one of the cells the formula is referencing.

The foregoing also holds for the second formula.

The third formula would return such error if D8+E8 is 0 or the foregoing stipulation holds.

What formulas do you have in the cells these formulas refer to?

 

[redneckopen]

This works but gives the #DIV/0! message when there is no entries with this formula which does work. but I get an error message when I try to add the ISERROR statement???

This works
=IF(M8>P8,M8-(L8/2),P8-(O8/2))

This does not...
=IF(ISERROR((M8>P8,M8-(L8/2),P8-(O8/2)),"",(m8>p8,m8-(l8/2),p8-(o8/2))

help please

 

[redneckopen]

Here is the sheet:

OverTime.xls
	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1
2		Punchrate
3		$4.50
4
5
6
7	HrlyRate	StraitHrs	OtHrs	Punches	RegWage	ExcessOt	Total	avewage/hr	averegttl	aveotttl	AVETTL	Reg$	OT$	TTL$
8	6.75	40	8	70	$301.88	$39.38	$341.25	6.5625	262.5	78.75	341.25	270	12	282
9	6.75	40	1	25	$270.75	$0.75	$271.50	2.74390244	109.7561	4.11585	113.872	270	1.5	272
10	6.75	40	3	36	$272.25	$2.25	$274.50	3.76744186	150.6977	16.9535	167.6512	270	4.5	275
Sheet2

 

[redneckopen]

Please help with this

 

[pedro-egoli]

With my limited no how it appears you are mixing up arguments.

Perhaps a different tack like

=IF(ISBLANK(E8),"",IF(M8>P8,M8-(L8/2),P8-(8/2)))

I could not ascertain (don't know how to export your sheet to my excel file) which cell, triggered calculations in other cells so selected E8.

Hope this helps and if someone can tell me how to export the HTML sheet above to excel would be appreciated.

Pedro

 

[Chas17]

This works but gives the #DIV/0! message when there is no entries with this formula which does work. but I get an error message when I try to add the ISERROR statement???

This works
=IF(M8>P8,M8-(L8/2),P8-(O8/2))

This does not...
=IF(ISERROR((M8>P8,M8-(L8/2),P8-(O8/2)),"",(m8>p8,m8-(l8/2),p8-(o8/2))

help please

=IF(ISERROR(IF(M8>P8,M8-(L8/2),P8-(O8/2))),"",IF(M8>P8,M8-(L8/2),P8-(O8/2)))

Chas