Help with IFERROR function (adding it onto an equation)

Occasional Visitor

I want to use the IFError function in this equation to avoid getting the #Value! result  and instead have a blank cell for those circumstances where the error would appear

 

=IF(ISBLANK(B12),"",IF(U12="Perpetual",(R12*P12),IF(U12="CWA",(Q12*P12),IF(U12="T.E.H.",(Q12*P12),IF(U12="Subscription",(Q12*P12),IF(U12=" ","TBD"))))))

 

Thanks

0 Replies