|
|
|
|
#1
09-16-2014, 05:40 AM
|
|||
|
|||
If formatting
Hi, first time I have used this forum so hope this makes sense.
I have a spreadsheet that I want to be able to give me 3 different answers to. column A = 17 column B = 20 Column C, I want this to give me a 0 if column A & B are the same, a 1 if A is greater than B and 2 if A is less than B. I can do the greater than or less than but can't work out how to input an answer if they are the same, for example they both say 20 = 0 Any help would be great. 
|
|
#2
09-16-2014, 07:27 AM
|
||||
|
||||
|
=if(a1=b1,0,if(a1>b1,1,2))
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Find and Replace, Formatting, Formatting Formula | kjxavier | Word | 1 | 07-04-2014 09:11 AM |
 Conditional formatting that ignores other formatting rules
|
info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
| Formatting contents after Tab of continuous lines or formatting specific area of word | pawii | Word | 1 | 05-12-2014 05:24 AM |
Windows 7 32bit 
Office 2010 32bit
If formatting - Many Thanks
Hybrid Mode