Need Help with Formula....

[Mykro]

I have a problem getting this formula to work.. It only works when there are numbers in C3 and J3, otherwise I get a FALSE in the cell..

The boards help is greatly appreciated.. Thank You..

=IF(ISERROR(IF(ISNUMBER(C3),IF(D3=3,(J3/C3)*1.25,IF(D3=4,(J3/C3)*1.67,IF(D3=5,(J3/C3)*0.625))))),"",IF(ISNUMBER(C3),IF(D3=3,(J3/C3)*1.25,IF(D3=4,(J3/C3)*1.67,IF(D3=5,(J3/C3))))))

 

[Scott T]

What do you want to be returned if there is not a number in C3?

When you do not specify what should be returned if the condition is false excel will return FALSE.

 

[KDecker]

Try this:

=IF(ISNUMBER(C3)="FALSE","",IF(ISERROR(IF(D3=3,(J3/C3)*1.25,IF(D3=4,(J3/C3)*1.67,IF(D3=5,(J3/C3)*0.625)))),"",IF(D3=3,(J3/C3)*1.25,IF(D3=4,(J3/C3)*1.67,IF(D3=5,(J3/C3)*0.625,"")))))

 

[Mykro]

Try this:

=IF(ISNUMBER(C3)="FALSE","",IF(ISERROR(IF(D3=3,(J3/C3)*1.25,IF(D3=4,(J3/C3)*1.67,IF(D3=5,(J3/C3)*0.625)))),"",IF(D3=3,(J3/C3)*1.25,IF(D3=4,(J3/C3)*1.67,IF(D3=5,(J3/C3)*0.625,"")))))

WOW..! It Works.. I never would have got that one.. Thank You..!