Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 15th 06, 11:04 AM posted to microsoft.public.excel.misc
recklaw
 
Posts: n/a
Default Help required for formula


I want to utilise a formula in excel, but am not sure exactly how to
enter it
My formula needs to do the following: -

If (AB) then display x
If (A<B) then display y
If (A=B) then display z

Naturally I would prefer to do this in one cell.

Using the If command it would appear I could set the formula to say :
-

=IF(A1B1,"X","Y")

However this will only display X if A is greater than B and Y if A is
less than or equal B.

Is there a way to work out the three different values?


--
recklaw
------------------------------------------------------------------------
recklaw's Profile: http://www.excelforum.com/member.php...o&userid=32469
View this thread: http://www.excelforum.com/showthread...hreadid=522572


  #2   Report Post  
Old March 15th 06, 11:11 AM posted to microsoft.public.excel.misc
davesexcel
 
Posts: n/a
Default Help required for formula


=IF(A1=B1,"Z",IF(A1<B1,"Y","X"))
This should work


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=522572

  #3   Report Post  
Old March 15th 06, 11:11 AM posted to microsoft.public.excel.misc
recklaw
 
Posts: n/a
Default Help required for formula


Just to let you all know I managed to work it out
I nested my formula using the following: -

=IF(A2B2,"X",IF(A2<B2,"Y", IF(A2=B2,"Z")))


--
recklaw
------------------------------------------------------------------------
recklaw's Profile: http://www.excelforum.com/member.php...o&userid=32469
View this thread: http://www.excelforum.com/showthread...hreadid=522572



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
can you make a cell value required? nishapurohit Excel Discussion (Misc queries) 2 January 30th 06 11:42 PM
highlighting required fields maryann Excel Worksheet Functions 2 June 23rd 05 06:16 PM
How do I set up some cells in a spreadsheet to be a required fiel. mickiemaggie Excel Worksheet Functions 1 March 1st 05 12:37 AM
SPECIFY REQUIRED PAPER SIZE IN EXCEL 2000 Augustine Excel Discussion (Misc queries) 0 January 17th 05 12:05 PM
Rate of return required formula Alorasdad Excel Worksheet Functions 1 November 18th 04 03:14 AM


All times are GMT +1. The time now is 10:36 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