Excel help IF function

[jonworth]

Hey im designing a system for a school project. However i've got a problem with IF functions. In a UserForm i have 2 option buttons for single and return flights, and on a spreadsheet i have a column called single/return in this colum i would like it to say either single or return flight, however i can get get numbers in the colum by using the formula =IF(J15=TRUE,1,2), therefore i figured if i changed these to (J15=TRUE,single,return), it would show on or the other but i get thr #NAME? error. Any ideas how to do it??? cheers

 

[99nasha]

Go to this site. They can answer your question there

http://www.mrexcel.com/board2/viewforum.php?f=2

 

[jonworth]

cheers 99nasha