Go Back   Computer Forums > General Computing > Hardware
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 03-11-2005, 10:31 AM   #1
Baseband Member
 
Join Date: Jun 2004
Posts: 26
Default Excel help IF function

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
__________________

jonworth is offline   Reply With Quote
Old 03-11-2005, 11:49 AM   #2
Fully Optimized
 
99nasha's Avatar
 
Join Date: Aug 2004
Posts: 2,995
Default

Go to this site. They can answer your question there

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

99nasha is offline   Reply With Quote
Old 03-14-2005, 05:47 AM   #3
Baseband Member
 
Join Date: Jun 2004
Posts: 26
Default

cheers 99nasha
jonworth is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 03:33 AM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0