Hello, where am I going wrong with this formula?
Solved/Closed
j1969c
Posts
20
Registration date
Friday August 28, 2015
Status
Member
Last seen
April 5, 2016
-
Dec 21, 2015 at 11:12 AM
j1969c - Dec 22, 2015 at 06:30 PM
j1969c - Dec 22, 2015 at 06:30 PM
Related:
- Hello, where am I going wrong with this formula?
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Credit summation formula - Guide
3 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Dec 21, 2015 at 11:22 AM
Dec 21, 2015 at 11:22 AM
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 September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Dec 21, 2015 at 11:33 AM
Dec 21, 2015 at 11:33 AM
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 August 28, 2015
Status
Member
Last seen
April 5, 2016
4
Dec 21, 2015 at 05:00 PM
Dec 21, 2015 at 05:00 PM
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 September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Dec 22, 2015 at 11:09 AM
Dec 22, 2015 at 11:09 AM
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 August 28, 2015
Status
Member
Last seen
April 5, 2016
4
Dec 21, 2015 at 11:30 AM
Dec 21, 2015 at 11:30 AM
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...
