So I have a spreadsheet with multiple tabs. I would like an entire row from one page to copy over to a new page within the same spreadsheet. I would like the color of a particular cell to trigger whether or not the entire row gets copied to the other tab in the workbook. Please let me know if this makes sense and again thanks for all the help!!
I've been doing some formulas for finding average percentage. However when checking the calculations I'm getting different results based on calculation method.
Here is an extremely simplified example.
Can anyone explain the math to me? why would i have a different percent based on these two methods of calculation? Should produce the same result, no?
does it have something to do with using negative values? (I don't believe this should have any effect)
Column A
Column B
B % of A
$37,350.00
$131.50
0.35%
$40,800.00
-$3,102.01
-7.60%
$14,720.25
-$414.22
-2.81%
-3.35%
I have the following script for calculation of one textbox plus another textbox, can someone please provide a script that I would use to calculate a percentage, i.e. 100 - 60% (answer 40).
I want this to be a textbox calculation within userform, I don't want to copy values to cells.
Code:
TextBox5.Value = CStr(CDbl(TextBox1.Value) + CDbl(TextBox3.Value))
I am trying to add percentage numbers and it is rounding up/down...Is there
any way to stop the rounding.
example
CELL C36 CELL D36 CELL E36
ACTUAL # =C36*(1-20%) =C36*(1-80%)
$169.82 $135.86 $33.96
$775.81 $620.65 $155.16
$945.63 $756.50 $189.13
WHEN I USE A BASIC ADDITION DOWN EACH COLUMN, I GET NUMBERS ROUNDED DOWN IN
COLUMN D AND NUMBERS ROUNDING UP IN COLUMN E. IS THERE ANY WAY TO GET THE
ACTUAL NUMBER.
THANK YOU
I want to create a function which defines a pulse wave that rises from
0 to 1, stays at one for a bit, lowers to 0, and stays at zero for a
bit.
/ if (t mod 1) <0.25, V(t) = 4* (t mod 1)
| if 0.5 >= (t mod 1) > 0.25, V(t) = 1
V(t) = |
| if 0.75> =(t mod 1) > 0.5, V(t) = 1-4* (0.75-(t mod 1))
\ if 1 > (t mod 1) > 0.75, V(t) = 0
For this pulse wave there are straight rises, falls and flat bottoms
and tops, which I need (and which is why a sine wave can't be used). If
you're still with me, thanks.
I can either put this all into a long excel equation for each cell that
I want this in (there will be about 4 'if' statements and 6 'mod'
statements) or create a UDF, where the t mod 1 only has to be
calculated once.
Any idea out there how much faster/ slower as UDF really is in a case
like this? Also, can you think of an easier way to create this pulse
wave?
As a side note, the t in my program has some ROW() and COLUMN()
dependence, and there will be 200+ cells filled with this equation
(thus, I can't just compute it once and copy the values to each cell).
Caculation speed is important because each cell is being calculated as
the time, t, is advanced by a timer.
Thanks in advance to anyone who takes a stab at this.
-Abe
Hello,
I have the following code as a check to make sure my form has been filled out correctly
Sheets("Budget Worksheet Year1").Select
If Range("Q3").value 1 Then
do stuff
Exit Sub
End If
In cell Q3 on that sheet I have a simple sum formula
=sum(e3:p3)
the cell is formatted as a percentage
the numbers entered add up to exactly 100%, or... 1
However when I run the macro, it determines that 100% is 1 so it runs the rest of my" if true "code
the do stuff and exit sub.
When I remove the formatting and make the 100% general, the cell displays as 1 and the if statement operates properly, skipping the do stuff and exit sub options.
I can't understand how formatting is preventing my if code to operate properly,
Can you help?
Dear all,
I have a question concerning workdays in Excel.
I would like to complete my dates, but would like to leave out Saturday and Sunday, because I have to track only workdays from Monday to Friday.
Have anyone an idea?
Thanks in advance!
Can anyone explain the rules for Excel SQL queries if they are.
For exampe is Inner/Outer join possible ?
Hi,
Has anyone created an effective (simple) rules engine in Excel that doesn't require VB coding or Add-ins etc. I'm looking to do a basic rules engine that includes a nice little distance look up too.
Something like: -
If condition A and condition B are met and distance between A and B is 10 miles use 456.
Each condition might have several options so it would be a lengthy exercise to go through each possible outcome.
That sort of thing...
Any advice gratefully received.
Thebadgerrogers
Hi, I need to create a monthly roster which schedules 2 people to be on duty each day. The parameters I need included a
1. No 2 same people should be together as far as possible (i.e. A & B, A & C, not A&B, A&B, ...)
2. When a person goes on leave, is there some kind of formula I can use to continue pairing people up with the above rule but 'replacing' this person who is away?
Also, anyone know how I can check older posts that I have made? I can't find a link which shows me all my posts, and so far have had to manually scroll through pages to try and look for my previous posts.
Thanks!
