# Hello, where am I going wrong with this formula? [Solved]

Ask a question j1969c 20Posts Friday August 28, 2015Registration date April 5, 2016 Last seen - Latest answer on Dec 22, 2015 06:30PM
=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...
See more
+7
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
Sure, try a file sharing site like www.speedyshare.com or ge.tt and post back the download link. Careful with sensitive information.
j1969c 20Posts Friday August 28, 2015Registration date April 5, 2016 Last seen -
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 1988Posts Sunday September 12, 2010Registration date ModeratorStatus September 19, 2016 Last seen -
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
j1969c-
OUTSTANDING! Worked like a charm! Thank you Trowa, I REALLY appreciate your help and effort.
Thankful, Jose