entering a converted amount in a column
In my excel spreadsheet two of the columns are "liters" and "US Gallons". In Canada I enter the liters (column a) but when in the US I would like to enter the gallons (column b) and have the converted liter amount entered automatically. I tried this
but it doesn't work =if(b2>0,a2=b2*3.7854,b2)
Keys to the Problem entering a converted amount in a column
Download SmartPCFixer to Fix It (Free)
How to Avoid Downloading Malware
Where are you getting the download?
There are malicious people who download valid copies of a popular download, modify the file with malicious software, and then upload the file with the same name. Make sure you are downloading from the developer's web page or a reputable company.
Don't install download manager
Many sites suggest or require you to install an installer or a download manager before allowing you to download a program you may be interested in downloading. These tools almost always cause your computer more problems and may even have malware or other spyware. Avoid any site claiming anything must be installed first before you can continue with your download.
Avoid advertisements on download pages
To help make money and pay for the bandwidth costs of supplying free the software, the final download page may have ads. Watch out for anything that looks like advertisements on the download page. Many advertisers try to trick viewers into clicking an ad with phrases like "Download Now", "Start Download", or "Continue" and that ad may open a separate download.
Cancel or deny any automatic download
Some sites may automatically try start a download or give the appearance that something needs to be installed or updated before the site or video can be seen. Never accept or install anything from any site unless you know what is downloading.
Another Safe way to Fix the Problem: entering a converted amount in a column:
How to Fix entering a converted amount in a column with SmartPCFixer?
1. Click the button to download Error Fixer . Install it on your system. Open it, and it will perform a scan for your system. The junk files will be shown in the list.
2. After the scan is finished, you can see the errors and problems need to be repaired. Click Fix All.
3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been removed.
Related: Download SONY SVE1512H1RB Synaptics PS/2 Port ClickPad driver
,Method to Download SONY VGC-LT10E SigmaTel Audio Driver Update v.6.10.5614.0
,Way to Download SONY VGN-CS118E/R AV Mode Button Utility v.1.1.01.09140 driver
,Method to Download SONY VGN-FW375J/B Alps Pointing Device Driver v.188.8.131.52
,Where to Download SONY VGN-NS270J/S Pioneer BD-ROM BDC-TD01 Firmware Update v.1.03
,Data Export From Quickbooks To Excel
,Date Format In Formula Bar And In The Cell Is Not The Same
,Deleted The Snipping Tool
,Desktop - Open Program Issues
,Desktop Windows Manager Keeps Poping Up & It Reads That There Is A Problem & That Windows Will Check It Out & Send Me An Answer .
Read More: Envelope printing problem in Word 2010
,How to Fix Error Equations won t print
,Troubleshooter of Error Error 0X 80070037
,[Solution] Error 0x8E5E0247 - trying to get home group set up
,Troubleshooting:error 0000007A opening the registry key at HKEY_LOCAL_MACHINE, how can i fix it?
,does anyone know what the dialog means "System.Media.FontFamily' threw an exception windows is checking for a solution?
,Does Log Me In Ignition for my Android with Windows 7 Home Premium?
,Download failure for my Blackberry and the process stops during the install
,Display settings keep changing when I come back from sleep mode
,Downloaded files are not saved