Report

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 
Helpful
+7
moins plus
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
Add comment
Helpful
+7
moins plus
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 - Dec 21, 2015 05:00PM
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.
Reply
TrowaD 1988Posts Sunday September 12, 2010Registration date ModeratorStatus September 19, 2016 Last seen - Dec 22, 2015 11:09AM
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
Reply
j1969c- Dec 22, 2015 06:30PM
OUTSTANDING! Worked like a charm! Thank you Trowa, I REALLY appreciate your help and effort.
Thankful, Jose
Reply
Add comment
Helpful
+4
moins plus
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...
Add comment

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!