Nested if statement format unclear

[ajoeiam]

Greetings

I have read a number of the nested if questions but have not found ‘my’ variant.
(If my variant has been discussed apologies and a request for the url to what I’m looking for.)

verbally - -
If E100 is greater than 265 and less than 528, E100, 0

how do I write the formula?

(I’ve found for a series of increasing numbers but not this greater than x and less than y combination)

[anon73440385]

Hello,

=IF(AND(E100>265;E100<528);E100;0)

BTW: This is not a nested IF, you have 2 conditions only, which is mathematically written as 256 < x < 528, which can be put into a single expression. So only one IF statement required.

Hope that helps.

If the answer is correct or helped you to solve your problem, please click the check mark () next to the answer.

[ajoeiam]

Thank you very much!