Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 18th 05, 03:23 AM
pajodublin
 
Posts: n/a
Default 2 Formulae 1 Cell


Hi,
Im trying to use 2 IF functions on the one cell.

My jobs consists of alot of printing with numerous types of paper each
numbered differently. Jobs that come in are all named differently and
use different forms. for example. the Job APTFEE uses ASC31 stationary,
whereas job R30EE uses RCT31 stationary.

Im trying to set up a form so when someone types in the job name the
type of paper will appear in the cell. I hope im making sense.

this is the formula ive been using, and changing it around for the last
4 hours without success...
=IF(A4="Aptfee","ASC31","False")OR(=IF,A4="r30ee", "RCT31","False")

Ive tried alot of different ones this one is just the current one ive
tried and i probably was closer before, any help would be much
appreciated
Thanks
Pajodublin


--
pajodublin
------------------------------------------------------------------------
pajodublin's Profile: http://www.excelforum.com/member.php...fo&userid=2804
View this thread: http://www.excelforum.com/showthread...hreadid=477026


  #2   Report Post  
Old October 18th 05, 03:33 AM
BenjieLop
 
Posts: n/a
Default 2 Formulae 1 Cell


pajodublin Wrote:
Hi,
Im trying to use 2 IF functions on the one cell.

My jobs consists of alot of printing with numerous types of paper each
numbered differently. Jobs that come in are all named differently and
use different forms. for example. the Job APTFEE uses ASC31 stationary,
whereas job R30EE uses RCT31 stationary.

Im trying to set up a form so when someone types in the job name the
type of paper will appear in the cell. I hope im making sense.

this is the formula ive been using, and changing it around for the last
4 hours without success...
=IF(A4="Aptfee","ASC31","False")OR(=IF,A4="r30ee", "RCT31","False")

Ive tried alot of different ones this one is just the current one ive
tried and i probably was closer before, any help would be much
appreciated
Thanks
Pajodublin



Try this ...

=IF(A4=\"APTFEE\",\"ASC31\",IF(A4=\"R30EE\",\"RCT3 1\",\"FALSE\"))

OR, if there are only 2 choices for A4, i.e, either it is "Aptfee" or
"r30ee" then your formula can be

=IF(A4=\"APTFEE\",\"ASC31\",\"RCT31\")

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=477026

  #3   Report Post  
Old October 18th 05, 03:36 AM
pajodublin
 
Posts: n/a
Default 2 Formulae 1 Cell


BenjieLop Wrote:
Try this ...

=IF(A4=\"APTFEE\",\"ASC31\",IF(A4=\"R30EE\",\"RCT3 1\",\"FALSE\"))

OR, if there are only 2 choices for A4, i.e, either it is "Aptfee" or
"r30ee" then your formula can be

=IF(A4=\"APTFEE\",\"ASC31\",\"RCT31\")

Regards.



thanks

that 1st one did the job, perfect
i knew i shouldve came here first.
Thanks again
Pajo


--
pajodublin
------------------------------------------------------------------------
pajodublin's Profile: http://www.excelforum.com/member.php...fo&userid=2804
View this thread: http://www.excelforum.com/showthread...hreadid=477026

  #4   Report Post  
Old October 18th 05, 04:51 AM
BenjieLop
 
Posts: n/a
Default 2 Formulae 1 Cell


pajodublin Wrote:
thanks

that 1st one did the job, perfect
i knew i shouldve came here first.
Thanks again
Pajo


Thank you for the feedback... glad I can help.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=477026



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
copying cell names Al Excel Discussion (Misc queries) 12 August 11th 05 03:01 PM
mixing text and formulae in same cell gvm Excel Worksheet Functions 9 July 19th 05 05:51 AM
Cell Change Color - Need Help alani New Users to Excel 3 June 29th 05 03:50 PM
how can i test whether cell contains keyed constant or a formulae Ruthki Excel Worksheet Functions 6 June 22nd 05 12:44 PM
VLookup resulting in a blank cell... KempensBoerke Excel Worksheet Functions 1 October 28th 04 09:57 PM


All times are GMT +1. The time now is 04:47 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright ©2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017