Search:

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

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    1
    Views
    85

    Marksheet formula

    Excel 2007



    Reg: Marksheet formula


    Columns B to J are in numerical format containing marks
    obtained.
  2. 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. Replies
    2
    Views
    137

    Re: Extract Max and relative date

    Thank you Sir, It works fine.
  4. Replies
    3
    Views
    111

    Re: date conversion

    Sir, I could not achieve result.
  5. 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
  6. 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
  7. Replies
    4
    Views
    126

    Re: sumproduct help

    Thank you Sirs
  8. 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. Replies
    7
    Views
    236

    Re: Average for given period

    Thank you Sirs,
  10. Replies
    7
    Views
    236

    Re: Average for given period

    I get #Div/0!
  11. 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.
  12. Replies
    7
    Views
    152

    Re: Conditional formatting

    I do not get result. Msg: Error in formula.
    Please help
  13. Replies
    7
    Views
    152

    Re: Conditional formatting

    Thank you Sirs
  14. 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. Re: sumifs with date and text criteria

    Thank you Sir, Great!
  16. 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. Re: sumifs with date and text criteria

    =COUNTIF(G5:G33,"TaxSave") Answer 1
  18. Re: sumifs with date and text criteria

    Microsoft Excel 2007
    =count(D5:D33) Answer 23
    =count(C5:C33) Answer 23
    =count(E5:E33) Answer 23
    =count(E5:E33)+countif(G5:G33,"TaxSave") Answer 24
  19. 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. Replies
    11
    Views
    445

    Re: IF condition problem

    Thank you, Mr Excel Sir, this works fine to achieve my requirement.
  21. 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. 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. Replies
    11
    Views
    445

    Re: IF condition problem

    Even if I 52 is <50, shows "Pass" (should be "Fail")
  24. 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. 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 2 3 4