Hi community, I am facing some issues to input the conditions when I use the IF formula. Can anyone please enlighten me on this?
So far, I have this formula,
=IF(B1
If you replace SUM((B1)-23000)*0.5+11000 with
MIN(57000, SUM((B1)-23000)*0.5+11000))),
the output will not exceed 57000.
By the way, I can see no reason for using the SUM function in your formula.
يتم ذلك عن طريق الصدق مع الاخرين والعمل الدؤب
i use 3 gr graphite H2SO4 120ml H3PO4 13,3 (9:1) and i varying KMnO4 10gr 15gr and 20gr with time process 8 hour (4 hour stirrer graphite H2so4 and H3PO4 temp 97 degg ) and 1 hour adding slowly...
20 August 2020 260 4 View
i use 3 gr graphite H2SO4 120ml H3PO4 13,3 (9:1) and i varying KMnO4 10gr 15gr and 20gr with time process 3 hour (2 hour stirrer graphite H2so4 and H3PO4 temp 97 degg ) and 30 minutes adding...
17 August 2020 4,928 14 View
I received a notice that 13 of my papers are not available on line.
09 April 2020 9,419 3 View
When I start PROCESS I get two error messages: ->Error 12410 Source operand for EVAL is not balanced. > >Undefined error #12354 - not found in file .. How can I solve this...
26 March 2020 6,738 2 View
If you have carried out national budget analysis for nutrition expenditure I would love to read your research findings
03 October 2019 5,213 2 View
I am working on my Final Year Project, interested to look into emotional measurement of consumers in selected food product. One of the aspects in emotion measurement, I am interested to find out...
01 October 2019 1,241 3 View
Hi everyone, Can anyone recommend a free HPLC prediction software/program to predict Retention times of a few molecules using various flow rates and/or columns? It would be very useful. Thank...
07 January 2019 5,181 6 View
Hi everyone, I am a student fairly new to experimental research! I am looking to do qPCR on different sarcoma samples to confirm the presence of TP53 (17p13.1). Since I am not seeking the presence...
10 December 2018 3,810 5 View
First of all, I am a student who's doing a project for the first time. For simplicity's sake, the current goal is to plot a Fluorescence/ DNA concentration curve using propidium iodide. Since...
14 September 2018 3,520 3 View
May I know what is the best cell density after 24 hours for Lipofectamine RNAiMax reagent for microRNA transfection in shsy5y cell line? Is reverse transfection recomended?
07 January 2018 6,724 9 View
Hello! I have a dataset of n=3000 nested within 8 countries with approximately 200 or 400 responses in each country. I originally planned to perform multilevel modelling with 4 dependent variables...
02 March 2021 6,865 1 View
An article that is published as a case study in the SJR listed journal. How much value is added to a researcher career? How it is evaluated by a scientific researcher/University admission...
02 March 2021 9,661 3 View
To dear Researchers, I was analyzing a series of concentration for estimation of Real-Time PCR efficiency. The concentration was 1:10. I used MS-excel to evaluate Slope. The result of slope was -8...
01 March 2021 8,683 4 View
Hi everyone, I would like to ask how I can download BibExcel software for MacOs? There are some links which are supported by Windows but I could not find it for Mac. or is there any other software...
01 March 2021 652 1 View
I am trying to seek out some Transgenomic Wavemaker software (happy to purchase a computer too) to operate a fraction collector. The only way to connect to the fraction collector so far is to...
23 February 2021 9,181 1 View
Hi I want to compare the running time of robotic path planning algorithms. The grid size is 8X8. I have 100 scenarios of start and goal positions.. Each scenario is run in three obstacles ratio...
22 February 2021 621 1 View
This is the unanswered question stored very long in my mind and till now I could not find a right answer. Google search educated me that the red surface is the PTFE material compatible to wider...
21 February 2021 546 3 View
Good evening everyone. If a questionnaire has 4 factors measuring different constructs as for example CAMI questionnaire measuring attitudes toward the mentally ill that has four factors:...
18 February 2021 3,223 3 View
Hi supreme hive-mind of the internet, we have some old *.MTS files that are supposed to contain spectroscopic data, probably some coordinates and a long list of single line spectra. Basically,...
16 February 2021 9,385 2 View
15 February 2021 1,997 6 View