Trying to create and IF formula where there is sometimes nothing to calculate against (just want "" to return) and other times where the calculation varies between currency and percentages. Think I'm close because I've avoided FALSE returns when I segment certain areas of the formula but not when I try to make everything work. Simple example of what I'm trying to do is attached. TIA!
It would be helpful if you described what you want the formulas to do, and show sample desired results. I am going to make some guesses here on context. But I don't know what you are trying to do with your calculations, so I'll assume that part's OK and you just have a logic problem.
This formula in B7 is returning FALSE
Formula:
=IF(E7=0,IF(D7=0,"",IF(E7>0,(-E7/G7)+1+$C$2,D7/G7-1)))
That is because E7 is blank. In that case, E7=0 will evaluate as TRUE, so your IF function will return the FALSE case. But your formula doesn't have a FALSE case, so it just returns FALSE. I think you want this:
Formula:=IF(OR(E7=0,D7=0),"",IF(E7>0,(-E7/G7)+1+$C$2,D7/G7-1))
Exactly the same problem with the formula in B10:
Formula:=IF(E10=0,IF(D10=0,"",IF(E10>0,(-E10/G10)+1+$C$2,D10/G10-1)))
update to
Formula:=IF(OR(E10=0,D10=0),"",IF(E10>0,(-E10/G10)+1+$C$2,D10/G10-1))
Same problem with all the formulas, but I think you can see how to fix them from these examples.
Last edited by 6StringJazzer; 01-03-2025 at 07:05 PM.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
JRay0108 
Register To Reply
Bookmarks