Forum Discussion
formula value error pls help
I M EXTENDING THE FORMULA FOR MULTIPLE VALUES ITS SHOWING VALUE ERROR , PLEASE HELP ME REGARDING THIS, EXTENDED FORMULA IS MARKED GREEN. I HAVE MULTIPLE 4 CONDITIONS THATS WHY I M EXTENDING THE FOR...
Perhaps, this is the formula you need:
=IF(AND(B5-C5>=-200,B5-C5<=-1),B5-C5,
IF(B5-C5=-750,-150,
IF(B5-C5=-650,-50,"")))
yes Twifoo , well thanks for resolving my issue.