Hi new to board and pretty new to excel got question

[morpheous]

iv tried to do a fomula in Cell A1, Were Cell A3 is >=A2 OR A3 < A2 & >A4 OR =<A4 if posabile

 

[hagia_sofia]

What is that you want to return? It could e.g. be something like this:

=IFS(A3>=A2;"1st";A(A3<A2;A3>A4);"2nd";A3<=A4;"3rd")

or

=IF(A3>=A2;"1st";IF(AND(A3<A2;A3>A4);"2nd";IF(A3<=A4;"3rd")))

but this only returns the information which one stands.

 

[Alex Blakenburg]

Welcome to the Forum. I seem to have interpreted the question the same way as hagia_sofia and come up with a slight variation.

=IF(A3>=A2,"1st condition",IF(A3>A4,"2nd Condition","last condition"))

By the way, the suggested solution can often vary depending on what version of Excel you are using so having your version as "Prefer not to say" means that you may not get the answer that best suits your requirements and may get answers that you can't actually implement.