formula in text field

[tbcwarrior]

hi i have a text field in with this calculation

=([Total amount requested]+[text3])/[Initial valuation]

it displays a div/0 error which i want to remove, i know i need to put this calcualtion in an iif statement but whenever i try and make the formula it never works

=iif([Total amount requested]+[text3])/[Initial valuation],?,""

where the question mark is i am not sure what should go there, as i want the total to of the calculation there and if 0 hide 0 with the ""

this has been bugging me for a while now and i can just get my head around it, probably very simple for someone to answer

regards
chris

 

[boblarson]

=IIf([Initial valuation]<>0,([Total amount requested]+[text3])/[Initial valuation],0)

 

[RuralGuy]

Try:
=IIF([Initial valuation]<> 0,[Total amount requested]+[text3])/[Initial valuation],"")

 

[tbcwarrior]

sorted

Thanks Guys the code was =IIf([Initial valuation]<>0,([Total amount requested]+[text3])/[Initial valuation],"")

all working nice thanks very much,

new to access

chris