CODEWITHSUNDEEP
excelexcel-formula
TourEiffel
TourEiffel

Reputation: 4434

Excel - AND formula not workig as excepted (Need to get value returned by formula)

I am using this formula :

=IF(AND(G767<>0;I767=0);TRUE;FALSE)

G767 and I767 Contains number. Why does this formula return 0 and not TRUE or FALSE

Sound Like AND Does not work as excepted

EDIT

G767 and I767 are given thanks to Formula, I need and AND don't take the formula's value but only the formula so how can I select the values returned by the formula and not the formula ?

Example :

G767 and I767 are given with this forumla :

=IF(G767<>0;'Primary Pricer'!$J$57*Pricing_Calculation!F761;IF(G767=0;'Primary Pricer'!$J$57*Pricing_Calculation!F761+'Primary Pricer'!$J$57))

Upvotes: 1

Views: 48

Answers (2)

Steven Pomponio
Steven Pomponio

Reputation: 340

Check to see if there are any circular references found within the document.

Under Formulas -> Error Checking -> Circular References

enter image description here

If possible, try and remove the circular reference, however if you can't you can change the settings to let it run.

Under File -> Options -> Formulas -> Enable iterative calculation enter image description here

Upvotes: 2

Vignesh
Vignesh

Reputation: 1623

change it to string by adding quotes ""

=IF(AND(G767<>0;I767=0);"TRUE";"FALSE")

Upvotes: -1

Related Questions