-
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.
introduce
-
M
Format for hours
I want to introduce a number with COMMAS for decimals and I want excel to add "hours". For example, if I introduce 6 in a cell I want to see 6 hours or 6,00 hours, I don't care. Or if I introduce 6,43 I want to see 6,43 hours. Which format should I use to get that? Thanks!- MakezHD
- Thread
- comma format hours introduce
- Replies: 7
- Forum: Excel Questions
-
S
Wrapping a selection of cells containing formulas and constants within an IF statement
Hi there I am trying to introduce a toggle in my financial model wherein if the toggle is OFF then a of the business unit's P&L and BS wont be counted towards the consolidated total. I already have the P&L and B&S in the excel and now I have to introduce the IF statement around the driver cells...- sps21
- Thread
- cells introduce p&l statement toggle
- Replies: 6
- Forum: Excel Questions
-
D
Calculate the average recurrence interval for a specific number; based on a condition
Hi, Assuming I put my chosen value, e.g. 1, in B1: Im currently using the following formula =MMULT(AGGREGATE({14,15},6,ROW(A1:A1000)/(A1:A1000=B1),1),{1;-1})/(COUNTIF(A1:A1000,B1)-1) I want to introduce a condition so for the above to work only when across A values where the values in...- D_Spark
- Thread
- condition formula introduce values work
- Replies: 9
- Forum: Excel Questions
