Is there an =IF function for something like this...?

[schuttedog]

2200/2000

5000/7500


Is there a formula I can input to have a result of the lower of the 2 numbers that are separated by a '/'?

Is these examples I would want the formula to come back with answers of 2000 and 5000.

The numbers are not constant and I have a big amount of data to parse and I don't want to do it manually.

Thanks.

[Pete_UK]

If your data is in A1, you could use this in B1:

=MIN(LEFT(A1,FIND("/",A1)-1),RIGHT(A1,LEN(A1)-FIND("/",A1)))

then copy down as required.

Hope this helps.

Pete

[schuttedog]

Yes! Thank you very much. Do you take btc donations? I'd like to send a little if you do.

[Pete_UK]

Glad to help, but I don't know what a btc donation is, All help here is offered free of charge, so you can donate some money to charity if you wish.

You can show your appreciation and directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Also, you can indicate that your question has been resolved by clicking on Thread Tools just above and to the right of your first post in this thread, and marking the thread as SOLVED.

Pete

[schuttedog]

Ok, thanks again!
I added reputation and marked as solved.