Trying to eliminate #VALUE! error from the formula by inserting ISERROR

[fullspeed]

Hello,
I am trying to eliminate #VALUE! error from the fomula below but I can't seem to figure it out. It is turning #VALUE! when there is no value in $CQ$7. So what I want to try is to insert ISERROR, hoping that that would get rid of #VALUE! and show the cell blank when there is no varibales available to do the calculation.
Thank you in advance for your help.

=IF(AND($F6="OPTION",$AC6<=$CV$3),$CQ$7-($AF6/$CU6),IF(AND($F6="SAREQUITY",$AC6<=$CV$3),$CQ$7-($AF6/$CU6),""))

 

[Momentman]

=IFERROR(if(and($f6="option",$ac6<=$cv$3),$cq$7-($af6/$cu6),if(and($f6="sarequity",$ac6<=$cv$3),$cq$7-($af6/$cu6),"")),"")

 

[ExcelMercy]

You could add an IF to the start to check whether CQ7 has a value. If it does, go on with the rest of the formula, if not, put a blank.


=if(CQ7=0,"", IF(AND($F6="OPTION",$AC6<=$CV$3),$CQ$7-($AF6/$CU6),IF(AND($F6="SAREQUITY",$AC6<=$CV$3),$CQ$7-($AF6/$CU6),"")))

 

[fullspeed]

=IFERROR(if(and($f6="option",$ac6<=$cv$3),$cq$7-($af6/$cu6),if(and($f6="sarequity",$ac6<=$cv$3),$cq$7-($af6/$cu6),"")),"")

Thank you so much, This worked perfectly!!

 

[fullspeed]

Since CQ7 can either be blank or value (not 0), I changed it to
=IF(CQ7="","", IF(AND($F6="OPTION",$AC6<=$CV$3),$CQ$7-($AF6/$CU6),IF(AND($F6="SAREQUITY",$AC6<=$CV$3),$CQ$7-($AF6/$CU6),"")))

and it worked perfectly. thank you very much.