Floorfiller
New Member
- Joined
- Jan 3, 2008
- Messages
- 48
Hey guys,
I need some help making this formula work properly.
I have the following:
=IF(OR(D73=" - ",Q73=" - ")," - ", (IF(AND(D73>0,Q73>0),((Q73/D73)-1)," - ")))
this equation is functioning properly for most situations.
1. number to number
2. "-" to "-"
where it is not working is when i end up comparing
3. "-" to number
and I'm getting the #VALUE! error because they aren't similar cell types.
anyone have any thoughts on how to get this to work properly?
i have the OR statement in there because if either of the cells is "-" i want it to default to "-" and stop the comparison, but it doesn't seem to be working.
appreciate your incite.
I need some help making this formula work properly.
I have the following:
=IF(OR(D73=" - ",Q73=" - ")," - ", (IF(AND(D73>0,Q73>0),((Q73/D73)-1)," - ")))
this equation is functioning properly for most situations.
1. number to number
2. "-" to "-"
where it is not working is when i end up comparing
3. "-" to number
and I'm getting the #VALUE! error because they aren't similar cell types.
anyone have any thoughts on how to get this to work properly?
i have the OR statement in there because if either of the cells is "-" i want it to default to "-" and stop the comparison, but it doesn't seem to be working.
appreciate your incite.