Hello, where am I going wrong with this formula?
Solved/Closed
j1969c
Posts
20
Registration date
Friday 28 August 2015
Status
Member
Last seen
5 April 2016
-
21 Dec 2015 à 11:12
j1969c - 22 Dec 2015 à 18:30
j1969c - 22 Dec 2015 à 18:30
Related:
- Hello, where am I going wrong with this formula?
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Instagram account based in wrong country - Instagram Forum
- Formula to calculate vat in excel - Guide
- Credit summation formula - Guide
- Spreadsheet formula - Guide
3 responses
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
21 Dec 2015 à 11:22
21 Dec 2015 à 11:22
Hi J1969c,
You are missing a condition:
IF M10>11.8 THEN ,"CNB" ELSE P10
So it is either "CNB" or P10.
What is the condition for?:
P10+ROUND(SUM(O10*O10*M10*0.7854)/10000,3)
Once you know that, formula should be:
=IF(CONDITION,P10+ROUND(SUM(O10*O10*M10*0.7854)/10000,3),IF(M10>11.8,"CNB",P10))
Best regards,
Trowa
You are missing a condition:
IF M10>11.8 THEN ,"CNB" ELSE P10
So it is either "CNB" or P10.
What is the condition for?:
P10+ROUND(SUM(O10*O10*M10*0.7854)/10000,3)
Once you know that, formula should be:
=IF(CONDITION,P10+ROUND(SUM(O10*O10*M10*0.7854)/10000,3),IF(M10>11.8,"CNB",P10))
Best regards,
Trowa
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
21 Dec 2015 à 11:33
21 Dec 2015 à 11:33
Sure, try a file sharing site like www.speedyshare.com or ge.tt and post back the download link. Careful with sensitive information.
j1969c
Posts
20
Registration date
Friday 28 August 2015
Status
Member
Last seen
5 April 2016
4
21 Dec 2015 à 17:00
21 Dec 2015 à 17:00
The CONDITION is that the result of this formula must be the value in cell P10 plus ROUND(SUM... [HOWEVER] if value in cell M10 is higher than 11.8 cell AV10 should show "CNB" otherwise just show the original value in cell P10.
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
22 Dec 2015 à 11:09
22 Dec 2015 à 11:09
It seems you are confused as to what a condition is.
A condition can either be true or false.
You have given 1 condition: M10>11.8
If this is true then the result is: "CNB"
If this is false then the result is: P10
Now you want to add another result, so you also need to add another condition.
For example your condition for the ROUND formula could be: N10=""
So if N10 is empty then use ROUND formula, if N10 is not empty then check the other condition.
In the above scenario the formula will look like:
=IF(N10="",P10+ROUND(SUM(O10*O10*M10*0.7854)/10000,3),IF(M10>11.8,"CNB",P10))
Hopefully this clarifies things a bit more.
Best regards,
Trowa
A condition can either be true or false.
You have given 1 condition: M10>11.8
If this is true then the result is: "CNB"
If this is false then the result is: P10
Now you want to add another result, so you also need to add another condition.
For example your condition for the ROUND formula could be: N10=""
So if N10 is empty then use ROUND formula, if N10 is not empty then check the other condition.
In the above scenario the formula will look like:
=IF(N10="",P10+ROUND(SUM(O10*O10*M10*0.7854)/10000,3),IF(M10>11.8,"CNB",P10))
Hopefully this clarifies things a bit more.
Best regards,
Trowa
j1969c
Posts
20
Registration date
Friday 28 August 2015
Status
Member
Last seen
5 April 2016
4
21 Dec 2015 à 11:30
21 Dec 2015 à 11:30
Thank you Trowa, unfortunately still did not work... any way to attach the small file so you have a better idea? If not possible, thank you for your prompt and courteous reply. I really appreciate your time and effort...
