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


3 replies

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
510
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
7
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
510
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.
7
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.
0
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
510
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
0
OUTSTANDING! Worked like a charm! Thank you Trowa, I REALLY appreciate your help and effort.
Thankful, Jose
0
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...
4