Search : in
By :

If/Then Statment

Last answer on Oct 29, 2009 1:50:08 am GMT Nancy, on Oct 28, 2009 9:30:11 pm GMT 
 Report this message to moderators

Hello,

I want to use an if/then statement that will replace a number in a cell if another cell is 0. For example, if G2 is 0, then take G6 which is currently .63% and add .25% to it and replace the .63 with the answer

Configuration: Windows XP Internet Explorer 6.0

Best answers for « If/Then Statment » in :
If Statement in Macro Show
Conditional formatting with 4 IF statements Show
[Myth] aMSN allows you to know if someone has blocked you on WLM Show aMSN allows you to know if someone has blocked you on Windows Live Messenger Myth Reality Explanations Myth aMSN software allows us to know who blocked us on Windows Live Messenger. Reality FALSE Explanations When it was launched,...
What to do if a file cannot be deleted ShowWhat to do if a file cannot be deleted How to get rid of the file? Solution 1: Ensure that the file/folder is not in use Solution 2: Run your system on Safe Mode Solution 3: Download or update your Antivirus program Solution 4: Use...
How do I know if a website is secure? ShowHow do I know if a website is secure? Determine if you are on a secured page or not. Some web sites use a secure connection between the web site and your browser. This may be important to you, for instance, if you want to pay...
[Yahoo] Determine if my contacts are online Show[Yahoo] Determine if my contacts are online If you do not see if your contacts are online (if they still appear in gray, as "disconnected"), you may need to adjust proxy settings. In Yahoo Messenger, once connected, go to...
Operating Systems - MS-DOS - Tips ShowSetting the CD-ROM drive The CD-ROM drive is configured in the config.sys and autoexec.bat system files. The CD-ROM drive device driver must be configured in the config.sys file (even if the device is automatically detected in Windows). To do...
Spreadsheets - Conditional expressions ShowWhat is a Conditional Structure? Conditional structures are instructions that allow to test if a condition is true or not. Conditional structures may be associated together. To successfully execute these tests using logical functions, spreadsheets...
Spreadsheets - Mathematical Functions ShowStandard Functions Function Description ABS() This function returns the absolute value of a number. It therefore returns the number, if it is positive, or the opposite (positive) if it is negative ODD(value) Rounds a number up to the...
Ask your question Reply

1

 venkat1926, on Oct 29, 2009 1:50:08 am GMT

If you enter a formula is G6 it will delete the existing value is G6 and you cannot manipulate. Beside it will give circular reference.

but you can have a small macro 

Sub test()
If Range("G2") = 0 Then
Range("G6") = Range("G6") + 0.0025
End If

End Sub

   
Reply to venkat1926
Ask your question Reply
They need your help