-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
2017
-
C
How to Add a vertical Line to an Excel Chart to Mark an Event
Hello folks I am tracking the effect of using hormone disruption to control moths and I did 2 treatments, treatment 1 om May 12,2017 and treatment 2 November 17,2017.I want to mark off these 2 days on the chart so that the reader can see the effect of each treatment. Month Year-2017 Jan 6,2017...- clemkonan
- Thread
- 2017 dec nov treatment
- Replies: 1
- Forum: Excel Questions
-
S
Formula - 2018 dates not calculating but 2017 are
I am at a complete loss - The below formula was working fine until this year. =SUMIFS(Heartland[[Disputed Amount ]], Heartland[[Tran Type ]], "Chargeback of Sale ", Heartland[[RC ]], "83", Heartland[[IC Date ]], ">=" & C4, Heartland[[IC Date ]],"<=" & C5) +SUMIFS(Heartland[[Disputed Amount ]]...- Sg327
- Thread
- 2017 2018 dates formula heartland[[ic
- Replies: 1
- Forum: Excel Questions
-
Z
Sudden strange behaviour percentage format
I have a sudden strange behaviour of the % cell format in Excel 2017. What happens: Type any number, say 10 in a cell Select column Choose the % button or rightclick and format cell to percentage 10 becomes 1000%, not strange because Excel thinks percentage is number x 100 Retype 10 in cell...- Zand
- Thread
- 2017 excel format percentage problem
- Replies: 2
- Forum: Excel Questions
