Hello, where am I going wrong with this formula?
Solved/Closed
j1969c
j1969c - Dec 22, 2015 at 06:30 PM
- Posts
- 20
- Registration date
- Friday August 28, 2015
- Status
- Member
- Last seen
- April 5, 2016
j1969c - Dec 22, 2015 at 06:30 PM
Related:
- Hello, where am I going wrong with this formula?
- Uh oh, looks as though something went wrong. please try again later. - Forum - Yahoo Mail
- Keyboard typing wrong keys - Guide
- Lenovo laptop keyboard wrong characters ✓ - Forum - Laptop
- Instagram security code wrong email - Forum - Instagram
- Skype time is wrong - Guide
3 replies
TrowaD
Dec 21, 2015 at 11:22 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
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
Dec 21, 2015 at 11:33 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
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
Dec 21, 2015 at 05:00 PM
- Posts
- 20
- Registration date
- Friday August 28, 2015
- Status
- Member
- Last seen
- April 5, 2016
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
Dec 22, 2015 at 11:09 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
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
Dec 21, 2015 at 11:30 AM
- Posts
- 20
- Registration date
- Friday August 28, 2015
- Status
- Member
- Last seen
- April 5, 2016
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...