Hello, where am I going wrong with this formula?

[Solved/Closed]
Report
Posts
20
Registration date
Friday August 28, 2015
Status
Member
Last seen
April 5, 2016
-
 j1969c -
=P10+ROUND(SUM(O10*O10*M10*0.7854)/10000,3),IF(M10>11.8,"CNB",P10)

The final result in cell AV10 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.

Many thanks...


3 replies

Posts
2809
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 23, 2021
484
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
7
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
2809
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 23, 2021
484
Sure, try a file sharing site like www.speedyshare.com or ge.tt and post back the download link. Careful with sensitive information.
7
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
20
Registration date
Friday August 28, 2015
Status
Member
Last seen
April 5, 2016
4
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.
Posts
2809
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 23, 2021
484
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
OUTSTANDING! Worked like a charm! Thank you Trowa, I REALLY appreciate your help and effort.
Thankful, Jose
Posts
20
Registration date
Friday August 28, 2015
Status
Member
Last seen
April 5, 2016
4
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...