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

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

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,108,917
Messages
5,525,621
Members
409,657
Latest member
19JimRon72

This Week's Hot Topics

Top