#Value! question

Kind of a noob question but i have looked everywhere and cant figure out why i am getting #Value as the output for my IF formulas when false. The following formulas work fine when satisfied if true, but when false i want the cell to blank in one instance and display "N/A" in the other instances however i always get #Value!. I have tried resizing and reformatting the cells but that doesn't help either???

Thanks in advance!

=IF(E36>0, I35*E36, "")
=IF($P$11>0,ROUND((P17*(1-$P$12)/$P$13),2),"N/A")
=IF($P$11>0, P17-(U17*$P$13), "N/A")

When you are getting #Value!, what are in cells E36 and P11?

E36 = =IF(Info!P35>0, Info!P35, "")

P11 = =IF(Info!G34="20/10", "3", "") & IF(Info!G34="25/6", "2", "") & IF(Info!G34="33/7", "1", "")

just a reference these are to work up different payment schedules depending on which payment plan is selected.

Since those other cells are blank, change your formulas to:

=IF(E36<>"", I35*E36, "")
=IF($P$11<>"",ROUND((P17*(1-$P$12)/$P$13),2),"N/A")
=IF($P$11<>"", P17-(U17*$P$13), "N/A")

HTH

Jason

Thanks a bunch worked like a charm. I knew it had to be something simple, i just was drawing blank on what to try, never thought of that since it was a valid statement already.