# Search:

Type: Posts; User: Muthukrishnan V; Keyword(s):

Page 1 of 5 1

## Search: Search took 0.01 seconds.

by Muthukrishnan V
Replies
1
Views
85

### Marksheet formula

Excel 2007

Reg: Marksheet formula

Columns B to J are in numerical format containing marks
obtained.
2. ## Thread: Percentage multiplication and subtraction

by Muthukrishnan V
Replies
3
Views
76

### Percentage multiplication and subtraction

Excel 2007

Col B and Col C contain numbers in numericals.

I am calculating C24*75%, minus B7, minus B11, minus B15.
3. ## Thread: Extract Max and relative date

by Muthukrishnan V
Replies
2
Views
137

### Re: Extract Max and relative date

Thank you Sir, It works fine.

by Muthukrishnan V
Replies
3
Views
111

### Re: date conversion

Sir, I could not achieve result.
5. ## Thread: Extract Max and relative date

by Muthukrishnan V
Replies
2
Views
137

### Extract Max and relative date

Excel 2007

Column A contains dates in dd-mm-yyyy
Column B contains values in numericals.
Column C1 = Start Date 01-01-2019
Column C2 = End Date. 31-01-2019

A B

by Muthukrishnan V
Replies
3
Views
111

### date conversion

Excel 2007
Column A contains dates in dd-mm-yy format.
How to convert the dates into dd-mm-yyyy format?
Example: 28-02-09 to 28-02-2009
Thanks

by Muthukrishnan V
Replies
4
Views
126

### Re: sumproduct help

Thank you Sirs

by Muthukrishnan V
Replies
4
Views
126

### sumproduct help

Excel 2007

Formula in S3:
=SUMPRODUCT(--
(D3:D20,D23:D47,D51:D67,D70:D74,D77:D124,D129:D140,D143:
D153,D156:D157=R3),P3:P20,P23:P47,P51:P67,P70:P74,P77:P12
4,P129:P140,P143:P153,P156:P157)
9. ## Thread: Average for given period

by Muthukrishnan V
Replies
7
Views
236

### Re: Average for given period

Thank you Sirs,
10. ## Thread: Average for given period

by Muthukrishnan V
Replies
7
Views
236

### Re: Average for given period

I get #Div/0!
11. ## Thread: Average for given period

by Muthukrishnan V
Replies
7
Views
236

### Average for given period

Excel 2007

Column A contains dates in dd-mm-yyyy format.
Continuous dates like 07-08-2019, 08-08-2019, 09-08-2019 and so
on.

Column B contains numbers (round numbers) in numericals.

by Muthukrishnan V
Replies
7
Views
152

### Re: Conditional formatting

I do not get result. Msg: Error in formula.

by Muthukrishnan V
Replies
7
Views
152

### Re: Conditional formatting

Thank you Sirs

by Muthukrishnan V
Replies
7
Views
152

### Conditional formatting

Microsoft Excel 2007

Column E contains date in dd-mm-yyyy format.
E5 : 13-01-2020
E6 : 21-05-2020
E7 : 05-02-2020
E8 : 13-10-2019
Today is 29-07-2019. The next upcoming date is...
15. ## Thread: sumifs with date and text criteria

by Muthukrishnan V
Replies
9
Views
474

### Re: sumifs with date and text criteria

Thank you Sir, Great!
16. ## Thread: sumifs with date and text criteria

by Muthukrishnan V
Replies
9
Views
474

### Re: sumifs with date and text criteria

As requested in my first post, I want to sum from Column D; with start date condition from Column C;
with End date condition from column E; and text condition from Column G.
Kindly refer formula in...
17. ## Thread: sumifs with date and text criteria

by Muthukrishnan V
Replies
9
Views
474

18. ## Thread: sumifs with date and text criteria

by Muthukrishnan V
Replies
9
Views
474

### Re: sumifs with date and text criteria

Microsoft Excel 2007
19. ## Thread: sumifs with date and text criteria

by Muthukrishnan V
Replies
9
Views
474

### sumifs with date and text criteria

Microsoft Excel 2007:

I have the following formula in J45, which gives wrong answer as 0.
=SUMIFS(D5:D33,C5:C33,">="&H40,E5:E33,"<="&H41,G5:G33,"TaxSave")

D5:D33 Amount in numericals
20. ## Thread: IF condition problem

by Muthukrishnan V
Replies
11
Views
445

### Re: IF condition problem

Thank you, Mr Excel Sir, this works fine to achieve my requirement.
21. ## Thread: IF condition problem

by Muthukrishnan V
Replies
11
Views
445

### Re: IF condition problem

I reframe my problem:
Mark1 Mark2 Mark3 Mark Mark5 Result
Pass>10 Pass>15 Pass>20 Pass>50 Pass>100
20 30 40 ...
22. ## Thread: IF condition problem

by Muthukrishnan V
Replies
11
Views
445

### Re: IF condition problem

Sir, In the above example, kindly alter C52 input as 5. (If C52<10 Fail). Now P52 shows FALSE.
C52 fail marks and also I52 fail marks. Correct answer is FAIL. All conditions fromC52,E52,G52,I52...
23. ## Thread: IF condition problem

by Muthukrishnan V
Replies
11
Views
445

### Re: IF condition problem

Even if I 52 is <50, shows "Pass" (should be "Fail")
24. ## Thread: IF condition problem

by Muthukrishnan V
Replies
11
Views
445

### Re: IF condition problem

If I52 is less than 50, P52 should show "Fail". (Not "False")

Te above code says "too many arguments"
25. ## Thread: IF condition problem

by Muthukrishnan V
Replies
11
Views
445

### IF condition problem

Microsoft Excel 2007

Column P52 contains this formula:
=IF(C52>10,IF(E52>15,IF(G52>20,IF(I52>50,IF(K52>100,"Pass","Fail")),"Fail")))
Columns C, E, G, I, K contain marks in numerical.
My...
Results 1 to 25 of 120
Page 1 of 5 1