Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can you make a cell value required? | Excel Discussion (Misc queries) | |||
highlighting required fields | Excel Worksheet Functions | |||
How do I set up some cells in a spreadsheet to be a required fiel. | Excel Worksheet Functions | |||
SPECIFY REQUIRED PAPER SIZE IN EXCEL 2000 | Excel Discussion (Misc queries) | |||
Rate of return required formula | Excel Worksheet Functions |