# 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
=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...

Related:

## 3 responses

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