Reduce size of formula with brackets included (Note:brackets used without CTL+Shift+Enter)

I have the following formula which works fine but I would like to reduce the size of the formula where the bracket start and end because I need to add else data. I have tried to substitute the data where the brackets moving it to another cell and link with this cell but formula does not work, also I tried to moving to other cell placing define name option but neither the formula works. Can you tell me if there is any alternative to reduce the size of this formula specifically where the brackets are?

=IF(F23<>"",(IF(OR($F$3={1030,1060,1080,1085,1270,1310,1325,1370,1365,1380,1385,1100,1160,1190,1050,1070,1410,1420,1425,1430,1435,1440,1445,1455,1465,1470,1475,7005,7205,2750}),(IF($F$10<>"USD",F23/$G$10,F23)),(IF($F$10="USD",F23*$G$10,F23)))),"")

Thanks
lucianir

Hi Cutter, thanks you so much for your response, but I will appreciate if you send me at all statement of the formula because I follow your suggestions but it worked partially, e.g when D10=USD and match with some item listed in my bracket formula in F3 sustituted for your formula countif, the outcome expected is wrong, maybe I can have understood your formula wrong, in this sense I ask you send me at all statemennt of the formula in order to test it. Thanks in advance.

Lucianir

OK, I'll give it a shot (not as easy as it would be to have a sample file to work with):

=IF(F23<>"",IF(COUNTIF(list,$F$3),(IF($F$10<>"USD",F23/$G$10,F23)),(IF($F$10="USD",F23*$G$10,F23))),"")

On closer look you do need preceding brackets 2 of the 4 IF()'s. I think that should do it. Replace the word list with the range that contains the list of values being checked for F3

Hi Cutter, I did test your formula and now is working fine, I have appreciated so much your help on this and I already posted a star for your reputation in this forum.
Lucianir

You're welcome. Thanks for the star tap but don't forget to mark your thread as SOLVED.