+ Post New Thread
Page 3 of 5614 FirstFirst 3 ...
Threads 101 to 150 of 280679

Forum: Excel Formulas & Functions

Post and discuss Excel Formulas & functions.

  1. Thumbs up Sticky Thread Sticky: Excel Useful Links (see last post for new additions)

    Started by gopi_excel‎, 12-22-2006 08:14 PM
    • 19
    • 156,902
    VBA Noob
    10-10-2007, 11:36 AM Go to last post

  1. Exclamation [SOLVED] Unable to remove data filter

    Started by mridul127‎, 03-23-2013 07:55 PM
    data, edit, file, locked, urgent
    • 4
    • 75,969
    FDibbins
    03-23-2013, 08:11 PM Go to last post

  2. [SOLVED] how to use "IF" to do nothing if a cell is blank

    Started by jimpc27‎, 11-21-2005 10:50 PM
    • 2
    • 75,901
    Biff
    11-21-2005, 11:10 PM Go to last post

  3. Calculate hours and minutes between two dates/times

    Started by farrellao‎, 10-18-2008 08:32 AM
    • 9
    • 74,634
    Fotis1991
    07-17-2014, 07:02 AM Go to last post

  4. Vlookup for 2 items

    Started by Mostafa‎, 07-14-2005 07:05 AM
    • 12
    • 73,559
    hpn88
    04-24-2008, 10:52 AM Go to last post

  5. Geometric Mean

    Started by Sir08‎, 02-17-2008 08:50 PM
    • 8
    • 73,437
    shg
    02-18-2008, 12:43 PM Go to last post

  6. [SOLVED] Excel: want neg numbers to show red/pos green via if-then formula

    Started by Jim‎, 06-15-2006 01:40 PM
    • 3
    • 72,355
    lk
    06-15-2006, 06:30 PM Go to last post

  7. ic50 calculation

    Started by irr‎, 12-29-2006 05:30 PM
    • 20
    • 71,915
    irr
    01-01-2007, 06:01 PM Go to last post

  8. Sales price volume mix variance analysis - who can explain!

    Started by Crawfinator1‎, 08-22-2013 08:53 PM
    7 Attachment(s)
    • 20
    • 70,875
    alansidman
    02-11-2021, 03:37 AM Go to last post

  9. IF statements using DATES

    Started by tttt‎, 04-12-2007 08:29 PM
    • 6
    • 68,962
    tttt
    04-13-2007, 12:51 AM Go to last post

  10. [SOLVED] Formula for tiered pricing

    Started by Unkilj‎, 01-28-2015 10:05 AM
    3 Attachment(s)
    • 17
    • 68,784
    AliGW
    06-22-2017, 01:19 AM Go to last post

  11. Convert date/time FROM UTC into EST with daylight savings.

    Started by mikeJ64‎, 09-04-2015 10:23 AM
    • 4
    • 68,678
    JohnTopley
    09-04-2015, 01:27 PM Go to last post

  12. [SOLVED] Product IF Function

    Started by freelancer820‎, 12-25-2014 09:31 PM
    product, productif, sumif
    • 5
    • 68,316
    Tony Valko
    12-26-2014, 08:00 PM Go to last post

  13. [SOLVED] Randbetween - not to repeat or duplicate

    Started by itselflearn‎, 05-01-2013 12:28 PM
    1 Attachment(s)
    • 11
    • 68,287
    Bullethead
    05-01-2017, 03:18 PM Go to last post

  14. [SOLVED] Automatically change text to uppercase

    Started by Santie‎, 02-22-2005 06:06 AM
    • 6
    • 68,282
    wheeljawk
    11-30-2020, 03:01 PM Go to last post

  15. if statement based on cell's color

    Started by luv2glyd‎, 09-04-2010 08:02 PM
    1 Attachment(s)
    • 18
    • 68,129
    romperstomper
    09-07-2010, 02:20 AM Go to last post

  16. Formula needed: count if cell CONTAINS certain text

    Started by Wim‎, 12-07-2005 08:30 AM
    • 12
    • 68,079
    RMoses
    08-01-2013, 08:14 AM Go to last post

  17. Excel 2007 : Sum divided by count

    Started by dancing-shadow‎, 07-20-2011 11:00 AM
    • 15
    • 67,279
    adnan.ahmad23
    03-20-2014, 10:28 AM Go to last post

  18. counting months between dates and returning a decimal

    Started by Mycotopian‎, 05-09-2007 02:02 PM
    • 22
    • 67,175
    unitx1
    09-12-2023, 01:09 AM Go to last post

  19. Formula for Calculating (Accrual) Vacation Time

    Started by usfscoop‎, 01-28-2009 10:31 AM
    2 Attachment(s)
    • 21
    • 67,091
    cbomb920
    01-27-2022, 10:02 AM Go to last post

  20. [SOLVED] Fomatting part of a formula to be Bold font

    Started by KimberlyC‎, 05-04-2005 07:06 PM
    • 7
    • 66,918
    [email protected]
    05-05-2005, 10:06 PM Go to last post

  21. Calculate Business Days in a month.

    Started by Dulanic‎, 06-16-2010 09:48 AM
    • 8
    • 66,823
    mikkelox
    04-15-2015, 10:43 AM Go to last post

  22. [SOLVED] AVERAGE function returns #DIV/0! error

    Started by KhaVu‎, 01-09-2006 02:10 PM
    2 Attachment(s)
    • 15
    • 65,691
    wlilley93
    11-13-2019, 12:09 PM Go to last post

  23. How to automatically refresh formulas?

    Started by berti‎, 08-13-2007 09:56 AM
    1 Attachment(s)
    • 14
    • 65,610
    THOMPDRE
    01-29-2014, 01:36 PM Go to last post

  24. Formula result to not exceed number

    Started by Coop913‎, 05-12-2009 08:38 AM
    • 3
    • 65,327
    Coop913
    05-12-2009, 08:51 AM Go to last post

  25. Forcing date format (dd/mm/yyyy) using data validation

    Started by reddwarf‎, 08-14-2009 04:44 AM
    data validation, dates
    • 5
    • 65,190
    AliGW
    03-12-2018, 01:48 AM Go to last post

  26. [SOLVED] Changing all formula references to absolute in a range of cells

    Started by warthog34‎, 02-06-2009 03:09 PM
    • 10
    • 65,056
    JBeaucaire
    07-08-2013, 08:16 PM Go to last post

  27. Formula to subtract a date from current date

    Started by Fidelio1st‎, 02-26-2006 11:07 PM
    • 3
    • 64,812
    Ryan Poth
    02-26-2006, 11:40 PM Go to last post

  28. IF statement including BETWEEN

    Started by simmerdown‎, 03-31-2006 04:20 PM
    • 17
    • 64,386
    Pete_UK
    04-03-2006, 11:00 AM Go to last post

  29. Calculate Years of Service

    Started by Jerry‎, 02-19-2005 10:06 AM
    • 5
    • 64,187
    Gilles Desjardins
    02-23-2005, 09:06 PM Go to last post

  30. Help making Negative numbers to become zero

    Started by jrabs12‎, 08-07-2006 11:33 AM
    • 15
    • 64,084
    08-08-2006, 04:00 AM Go to last post

  31. Why does the trim() function not working? This is so bizarre!

    Started by tjj‎, 08-10-2011 02:19 AM
    1 Attachment(s)
    • 4
    • 63,911
    belle14
    10-05-2016, 10:26 AM Go to last post

  32. [SOLVED] Macro to move down one cell.

    Started by richard11153‎, 02-19-2016 05:11 PM
    • 1
    • 63,428
    mucbeanz
    02-19-2016, 05:21 PM Go to last post

  33. Concatenate text w/ a percentage

    Started by dbrunner281‎, 10-16-2007 08:52 AM
    • 2
    • 63,293
    dbrunner281
    10-16-2007, 09:29 AM Go to last post

  34. [SOLVED] Combining SUMIFs and LEFT Functions

    Started by Jawshaw‎, 08-24-2017 10:49 AM
    • 6
    • 63,217
    Jonmo1
    08-24-2017, 11:20 AM Go to last post

  35. [SOLVED] #NUM errors when calculating IRR

    Started by [email protected]‎, 04-30-2006 02:25 AM
    • 7
    • 62,871
    [email protected]
    05-04-2006, 02:10 PM Go to last post

  36. [SOLVED] NVL type function

    Started by Jonathan‎, 05-11-2006 11:40 AM
    • 5
    • 61,994
    Jonathan
    05-16-2006, 03:10 PM Go to last post

  37. Using VBA to insert Columns

    Started by Michael‎, 07-25-2005 03:05 AM
    • 8
    • 61,875
    Michael
    07-25-2005, 07:05 PM Go to last post

  38. Permutation & Combinations

    Started by ashishseth‎, 02-08-2007 04:55 AM
    • 4
    • 60,553
    ashishseth
    02-08-2007, 05:58 AM Go to last post

  39. Question IF cell is empty, copy data from another cell on that row

    Started by thundercat77‎, 01-05-2007 05:14 PM
    • 2
    • 60,202
    thundercat77
    01-05-2007, 05:42 PM Go to last post

  40. Can I create a formula using concatenate?

    Started by rohed‎, 03-12-2007 01:32 PM
    • 15
    • 60,156
    ctruelove
    05-05-2022, 11:54 AM Go to last post

  41. Where are Bitwise Operators

    Started by Dennis W. Bulgrien‎, 06-30-2006 12:30 PM
    • 1
    • 59,557
    Dennis W. Bulgrien
    06-30-2006, 12:55 PM Go to last post

  42. Multiple search strings using FIND function

    Started by tg000001‎, 07-22-2008 07:16 AM
    • 2
    • 59,538
    ExcelKnut
    01-27-2014, 12:47 PM Go to last post

  43. how to count specific words in a cell range

    Started by 1.zer0‎, 06-17-2009 06:29 AM
    • 17
    • 59,496
    ghstnmachi
    10-08-2015, 12:02 PM Go to last post

  44. [SOLVED] Negative Numbers in Red Brackets, Positive Numbers in Accounting Format

    Started by STUARTXL‎, 12-24-2015 07:18 AM
    • 1
    • 59,320
    samba_ravi
    12-24-2015, 08:29 AM Go to last post

  45. Vlookup to return blank cell instead of #N/A

    Started by randell.graybill‎, 08-15-2009 07:34 PM
    • 10
    • 58,916
    Pepe Le Mokko
    08-25-2015, 12:10 PM Go to last post

  46. Help with structured references

    Started by hellur_kitty‎, 04-21-2013 04:08 PM
    • 10
    • 58,787
    FDibbins
    10-07-2013, 10:50 PM Go to last post

  47. [SOLVED] Input cell reference is not valid (One Variable Data Table)

    Started by Dottore‎, 09-01-2005 02:05 AM
    • 9
    • 58,619
    Max
    09-01-2005, 11:05 AM Go to last post

  48. Creating Excel bookmarks

    Started by Louise‎, 01-21-2005 12:06 PM
    • 4
    • 58,590
    teylyn
    02-13-2012, 05:59 AM Go to last post

  49. roadway station format

    Started by kc27315‎, 12-05-2007 12:28 PM
    • 9
    • 58,532
    alansidman
    03-07-2023, 11:20 PM Go to last post

  50. [SOLVED] SHORT CUT KEY(S) TO SHOW OR HIDE SEETS IN EXCEL

    Started by slow hand‎, 09-13-2005 01:05 PM
    • 5
    • 58,448
    Dave Peterson
    09-13-2005, 10:05 PM Go to last post
+ Post New Thread
Page 3 of 5614 FirstFirst 3 ...

Forum Information and Options

Users Browsing this Forum

There are currently 94 users browsing this forum. (3 members & 91 guests)

  1. cwwazy,
  2. etaf,
  3. leovilla

Thread Display Options

Use this control to limit the display of threads to those newer than the specified time frame.

Allows you to choose the data by which the thread list will be sorted.

Order threads in...

Note: when sorting by date, 'descending order' will show the newest results first.

Icon Legend

Contains unread posts
Contains unread posts
Contains no unread posts
Contains no unread posts
More than 15 replies or 150 views
Hot thread with unread posts
More than 15 replies or 150 views
Hot thread with no unread posts
Closed Thread
Thread is closed
Thread Contains a Message Written By You
You have posted in this thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1