• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

If calculation with AND OR

S

Sg2209

New Member
Dear Friends,

Could you please help me with the below Excel Formula, i know its very simple however tried several times and googled for several hours still confused why i am not getting the results

Need to Run the Formula in Column D

If B2 is greater than 0 then D2 = b2*103% Else

C2*55%

i have tried below Formulas and in both of it getting the formula in Cells instead of the result

1) =IF(AND(B2>"0",OR(C2="0")),"B2*103%",C2*55%) ( In this Getting Result for one conditio C2*55%) not getting 103%

2) =IF(AND(C2=0,B2>0),"C2*55%","B2*103%")

3) =IF(B2>"0","b2*103%","C2*55")
 
Sg2209 said:
Dear Friends,
i have tried below Formulas and in both of it getting the formula in Cells instead of the result
Click to expand...
Looking at what you wrote... Please check.
- Why do you put your numeric values between quotes? What if you'd dismiss those.
- Would your cells be formatted as text?
 
I have seen this same query on another forum today - you are aware, aren't you, that you need to provide cross-post links?
 
AliGW said:
I have seen this same query on another forum today - you are aware, aren't you, that you need to provide cross-post links?
Click to expand...

No that was different one on Excel Forum, i was trying to out this query there however its not getting opened up here, if you need i would share that question here.

Apologies if it confused
 
No
GraH - Guido said:
Looking at what you wrote... Please check.
- Why do you put your numeric values between quotes? What if you'd dismiss those.
- Would your cells be formatted as text?
Click to expand...
No i have formatted as General , Could you please let me know where i am putting quotes in what formula
 
Sg2209 said:
No that was different one on Excel Forum, i was trying to out this query there however its not getting opened up here, if you need i would share that question here.

Apologies if it confused
Click to expand...

If the question is difference, uploading a file with sample data and together with the expected result in Column D

Regards
Bosco
 
this time the condition is different with the same percentage however the project file is same, i tried using the above formula , if you still think the same i will upload the file .

i am not too much familiar with the excel formulas .
 
GraH - Guido said:
= IF(B2>"0","b2*103%","C2*55")
= IF (B2>0, B*103%, C2*55%)
Click to expand...
Sorry GraH-Guido - its not working for me, it throws an error #NAME?
i tried =IF(B2>"0",C2*55%,B2*103%) but it only gives the resolution for Column B, i also need when value is 0 in Column B than calculate from C column.
 
You must log in or register to reply here.
Back
Top