Timeline for In Excel is there a way to “turn on and off” the =min in a formula?
Current License: CC BY-SA 4.0
8 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
S May 20 at 17:49 | history | suggested | ChanganAuto | CC BY-SA 4.0 |
Code fenced
|
May 20 at 14:22 | review | Suggested edits | |||
S May 20 at 17:49 | |||||
May 19 at 13:43 | answer | added | karl | timeline score: 2 | |
May 17 at 1:27 | comment | added | EMD | Thank you bugdrown and Emily. I did this, but wish I had figured out how to nest the formula correctly. I couldn’t do it properly with the min formula too. I have another spreadsheet that I’ll test on tomorrow… | |
May 16 at 1:48 | comment | added | Emily | You may create a drop down list of "Yes"/"No". Then like bugdrown suggested above, us IF function to create the formula. | |
May 16 at 1:06 | comment | added | bugdrown |
Nest two versions of your formula inside an IF() statement, one using the MIN() portion and one without it. IF(A2="Yes", [formula if TRUE], [formula if FALSE]) .
|
|
S May 16 at 0:48 | review | First questions | |||
May 16 at 4:55 | |||||
S May 16 at 0:48 | history | asked | EMD | CC BY-SA 4.0 |