Related:
- Hello, where am I going wrong with this formula?
- Sorry, something went wrong please try closing and re-opening your browser window. - Forum - Facebook
- Whatsapp web time wrong - How-To - Mobile
- Gmail time is wrong ✓ - Forum - Gmail
- Google calendar icon shows wrong date ✓ - Forum - Google
- Keyboard shift key wrong character - How-To - Keyboard
3 replies
TrowaD
- Posts
- 2809
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- September 23, 2021
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
- 2809
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- September 23, 2021
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
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
- 2809
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- September 23, 2021
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
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...
