Home

How much free disk space to add or subtract to maintain 30% free space

%3CLINGO-SUB%20id%3D%22lingo-sub-325952%22%20slang%3D%22en-US%22%3EHow%20much%20free%20disk%20space%20to%20add%20or%20subtract%20to%20maintain%2030%25%20free%20space%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-325952%22%20slang%3D%22en-US%22%3E%3CP%3EI%20was%20wondering%20if%20any%20math%2Fexcel%20gurus%20could%20lend%20me%20hand%20with%20this%20problem%20I'm%20working%20on.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20use%20Excel%20to%20create%20a%20report%20that%20would%20tell%20me%20how%20much%20free%20space%20to%20add%20or%20remove%20to%20maintain%2030%25%20free%20space%20on%20a%20disk.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20attached%20an%20example%20of%20what%20I've%20been%20working%20on.%20Please%20let%20me%20know%20if%20there%20is%20anymore%20info%20I%20could%20provide.%20I%20appreciate%20any%20feedback.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-325952%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-326099%22%20slang%3D%22en-US%22%3ERe%3A%20How%20much%20free%20disk%20space%20to%20add%20or%20subtract%20to%20maintain%2030%25%20free%20space%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326099%22%20slang%3D%22en-US%22%3E%3CP%3EPerhaps%20something%20like%20this%3C%2FP%3E%0A%3CPRE%3E%3D(0.3*B2-D2)*(D2%26lt%3B0.3*B2)%3C%2FPRE%3E%0A%3CP%3Ein%20attached%20file%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
-o_d-
Occasional Visitor

I was wondering if any math/excel gurus could lend me hand with this problem I'm working on.

 

I'm trying to use Excel to create a report that would tell me how much free space to add or remove to maintain 30% free space on a disk.

 

I attached an example of what I've been working on. Please let me know if there is anymore info I could provide. I appreciate any feedback.

1 Reply
Highlighted

Perhaps something like this

=(0.3*B2-D2)*(D2<0.3*B2)

in attached file

 

Related Conversations