Thursday, September 29, 2016

Display a term next to a cell that falls within a given range ? [Anwsered]

Display a term next to a cell that falls within a given range ?

I am trying to display a term next to a cell that falls within a given range.
Column A has a list of accounts, and i would like column "B" to display the text; Asset, Liability, Clearing, or transfer, depending on what range the account number is in.
 
Classifications(there are really 10 classifications, but for an example I gave 4):
If an account number is greater than 1, but less than 500 , display "Asset"
If an account number is greater than 499, but less than 1000 , display "Liability"
If an account number is greater than 999, but less than 1500 , display "Clearing"
If an account number is greater than 1499, but less than 2000 , display "Transfer"
 
So, If column A has the value "1215", column B should display "Clearing".
 
ANY HELP IS GREATLY APPRECIATED!!!!

Keys to the Problem Display a term next to a cell that falls within a given range ?

Download Error Fixer for Free Now

Hello !

your "B" column should have the following function code to do the job!
=IF(AND(A1>1,A1<500),"Asset",IF(AND(A1>499,A1<1000),"Liability",IF(AND(A1>999,A1<1500),"Clearing",IF(AND(A1>1499,A1<2000),"Tranfer"))))

mark if answered :)

Regards,

VigenTOT

Make Sure that your System Meets the System Requirements

You need to double-check your computer's hardware configuration against the following Microsoft requirements. If your PC hardware is not up to par, then make sure you update where necessary before continuing:

Microsoft Windows Requirements :

  • 1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
  • 16 GB available hard disk space (32-bit) or 20 GB (64-bit)

Recommended Method to Fix the Problem: Display a term next to a cell that falls within a given range ?:

How to Fix Display a term next to a cell that falls within a given range ? with SmartPCFixer?

1. You can Download Error Fixer here. Install it on your system. When you open it, it will perform a scan.

2. After the scan is done, you can see the errors and problems which need to be repaired.

3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been fixed.


Related: Way to Update & Download SONY SVE14A2X1EH Wireless State Device driver,How to Update & Download SONY SVS1511X9RB Graphics Driver for D2 (Intel) v.9.17 - 9.17.10.2828,Method to Download SONY VGN-CR290N Realtek High Definition Audio Driver v.5.10.0.5433,Download SONY VGN-FS710/W Utilities DLL Update v.6.4.0.06290 driver,Method to Update & Download SONY VGN-NR460E/P Intel Graphics Media Accelerator Driver v.6.14.10.4847,How to Fix Error 0x0000c1f5 Solución?,Error 0x80071a91 Win7 Fix Patch,Error 0x800ccc60 Windows Live Mail [Solved],Error Message 0x800ccc79 Outlook 2000 Fix,What is Error 0xc1ab0001?,[Answered] x64 saplugin dll,How to Fix Problem - Kb943729 Download?,Troubleshooting: Bccode D1 Error,Java Runtime Tech Support,Troubleshooting: ERROR NO SUCH GROUP Error,Solution to ashoutxt.dll Missing Error,Solution to cxcore096.dll Missing Error,Where can I Find dsauth.dll File,How to Fix msde.dll Not Found Error,Best Method to Fix psizewizres.dll Error
Read More: Troubleshoot:Does anybody know how to make an installation image of Windows XP that I can install using a USB flash drive?,Troubleshooting:doing a system restore in windows 7 starter on hp mini netbook.still restoing for over an hour.is this normal?,Troubleshooter of Error: Does data connection close database session?,How to Fix Error - Does Windows Server 2012 Foundation include Group Policy Managment??,Troubleshooter of Error: Does anyone know how to turn off the automatic selection for a mouse?,Data validation question. Maintaining and updating named ranges.,Desktop Gadget Gallery on Windows 7,delete empty rows,Deleting a page and also how can I copy an exact page lay out on a new page,Date Formula for 1st Sunday of each Month (3rd to 9th)

No comments:

Post a Comment