Help with iserror

gordyzx9r

New Member
Joined
Mar 18, 2007
Messages
24
Trying to help out a friend with an excel issue:

I'm trying to make the following command return $0.00 if it returns a value of less than .005 or if it returns an error. I keep getting a divide by zero error and I cannot figure out where to put my closing paren to make it work properly.

The OR operand is (supposed to be) making it so that if I get an error OR I have an answer that is less than 0.005 then I should be giving a response of $0.00.


=IF(OR((ISERROR(C7/(C11-C13))),(C7/(C11-C13))<.005),"$0.00"),(C7/(C11-C13))
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
Try

=IF(C11-C13=0,0,IF(C7/(C11-C13)<.005,0,C7/(C11-C13)))
 

Domski

Well-known Member
Joined
Jan 18, 2005
Messages
7,292
Try:

=IF(OR(ISERROR(C7/(C11-C13)),C7/(C11-C13<0.005)),0,C7/(C11-C13))

Dom
 

Watch MrExcel Video

Forum statistics

Threads
1,109,131
Messages
5,527,019
Members
409,735
Latest member
viktor90

This Week's Hot Topics

Top