Hi new to board and pretty new to excel got question

M

morpheous

New Member
Joined
May 26, 2024
Messages
1
Office Version
  1. Prefer Not To Say
Platform
  1. Windows
iv tried to do a fomula in Cell A1, Were Cell A3 is >=A2 OR A3 < A2 & >A4 OR =<A4 if posabile
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
Sort by date Sort by votes
What is that you want to return? It could e.g. be something like this:

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

or

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

but this only returns the information which one stands.
 
Upvote 0
Welcome to the Forum. I seem to have interpreted the question the same way as hagia_sofia and come up with a slight variation.
Excel Formula: 
=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.
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Solved
Get Cell Difference in Array SCAN/LAMBDA
Replies
2
Views
136
MrRajKumar
M
S
  • Question
VBA／select contiguous cells as separate batches
2
Replies
11
Views
470
Joe4
Joe4
M
  • Question
How to find more than one word in Excel?
3 4 5
Replies
49
Views
900
Cubist
Cubist
J
  • Solved
If, and, or statement
Replies
4
Views
302
etaf
etaf
Q
  • Solved
Copying from one Worksheet to another repeatedly.
Replies
4
Views
85
qh017
Q

Forum statistics

Threads
1,216,500
Messages
6,131,015
Members
449,615
Latest member
Nic0la

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top