#VALUE! returned, but want cell to be blank if source cell is blank

[stully]

Good morning!

I want the cell to remain blank if there is nothing in the cell that I am referencing. Instead, it returns the #VALUE ! to the cell. Here is my formula:
=IF(P3="WAIVE",0,IF("EE Value",$R$130,IF(P3="EE Select",$P$130,IF(P3="ES Value",$R$131,IF(P3="EC Value",$R$132,IF(P3="EF Value",$R$133,IF(P3="ES Select",$P$131,IF(P3="EC Select",$P$132,IF(P3="EF Select",$P$133)))))))))
I am not sure what I am missing in order for the cell to return nothing in P3 is blank. Any help would be greatly appreciated!

Thank you!

 

[Fluff]

Try

=IF(P3="","",IF(P3="WAIVE",0,IF("EE Value",$R$130,IF(P3="EE Select",$P$130,IF(P3="ES Value",$R$131,IF(P3="EC Value",$R$132,IF(P3="EF Value",$R$133,IF(P3="ES Select",$P$131,IF(P3="EC Select",$P$132,IF(P3="EF Select",$P$133))))))))))

 

[Scott Huish]

There is an error in your formula, the second IF doesn't have a P3= before "EE Value". You're also missing a final FALSE parameter.

=IFERROR(IF(P3="WAIVE",0,IF(P3="EE Value",$R$130,IF(P3="EE Select",$P$130,IF(P3="ES Value",$R$131,IF(P3="EC Value",$R$132,IF(P3="EF Value",$R$133,IF(P3="ES Select",$P$131,IF(P3="EC Select",$P$132,IF(P3="EF Select",$P$133,""))))))))),"")

 

[stully]

Thank you very much! That worked and thank you for also noticing the error! I appreciate the help!