SOLVED

excel

%3CLINGO-SUB%20id%3D%22lingo-sub-3319492%22%20slang%3D%22zh-CN%22%3Eexcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3319492%22%20slang%3D%22zh-CN%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22wenhao2210_1-1651725480410.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F369356iD4B357DEE9F6D160%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22wenhao2210_1-1651725480410.png%22%20alt%3D%22wenhao2210_1-1651725480410.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIf%20D2%26lt%3B%20E2%20is%200%20or%20D2%26gt%3B%20F2%20is%200.6662%2C%20neither%20of%20which%20is%20the%20original%20value%2C%20ask%20how%20to%20play%20this%20judgment%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3319492%22%20slang%3D%22zh-CN%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3319799%22%20slang%3D%22en-US%22%3ERe%3A%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3319799%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1381527%22%20target%3D%22_blank%22%3E%40wenhao2210%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20sorry%2C%20but%20in%20this%20forum%2C%20we%20speak%20mostly%20English.%26nbsp%3B%20If%20you%20need%20further%20assistance%2C%20I%20suggest%20that%20you%20find%20someone%20who%20can%20translate%20for%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAccording%20to%20Google%20Translate%2C%20you%20wrote%3A%26nbsp%3B%20%60%60I'm%20new%20to%20excel%20and%20want%20to%20show%20G%20grid.%20If%20D2%3CE2%20is%3D%22%22%200%3D%22%22%20or%3D%22%22%20d2%3D%22%22%3EF2%20is%200.6662%2C%20if%20neither%20of%20them%20is%20the%20original%20value%2C%20how%20do%20I%20make%20this%20judgment%3F%60%60%3C%2FE2%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E(EDIT%3A%26nbsp%3B%20Aha!%26nbsp%3B%20After%20I%20refreshed%20the%20page%2C%20the%20Chinese%20was%20translated%20into%20English%20automatically.%26nbsp%3B%20But%20I%20think%20Google%20did%20a%20better%20job%20of%20translation.)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20the%20following%20is%20literally%20what%20you%20want%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(D2%3CE2%3EF2%2C%200.6662%2C%20D2))%3C%2FE2%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20I%20wonder%20if%20you%20really%20want%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(D2%3CE2%3EF2%2C%20F2%2C%20D2))%3C%2FE2%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ebecause%20I%20notice%20that%20F2%20is%20not%20exactly%200.6662.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20is%20equivalent%20to%20the%20following%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(D2%3CE2%3E%3C%2FE2%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENote%3A%26nbsp%3B%20Some%20languages%20use%20semicolon%20(%22%3B%22)%20to%20separate%20parameters%20instead%20of%20comma%20(%22%2C%22).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3320299%22%20slang%3D%22zh-CN%22%3ERe%3A%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3320299%22%20slang%3D%22zh-CN%22%3EThanks%20Joe%2C%20you%20helped%20me%20solve%20the%20puzzle%3C%2FLINGO-BODY%3E
New Contributor

wenhao2210_1-1651725480410.png

excel新手,想要讓G格呈現 如果D2<E2為0或D2>F2為0.6662,兩者都不是的話為原本數值,請問這個判斷是要怎麼打

2 Replies
best response confirmed by Sergei Baklan (MVP)
Solution

@wenhao2210 

 

I'm sorry, but in this forum, we speak mostly English.  If you need further assistance, I suggest that you find someone who can translate for you.

 

According to Google Translate, you wrote:  ``I'm new to excel and want to show G grid. If D2<E2 is 0 or D2>F2 is 0.6662, if neither of them is the original value, how do I make this judgment?``

 

(EDIT:  Aha!  After I refreshed the page, the Chinese was translated into English automatically.  But I think Google did a better job of translation.)

 

I think the following is literally what you want:

 

=IF(D2<E2, 0, IF(D2>F2, 0.6662, D2))

 

However, I wonder if you really want:

 

=IF(D2<E2, E2, IF(D2>F2, F2, D2))

 

because I notice that F2 is not exactly 0.6662.

 

That is equivalent to the following:

 

=IF(D2<E2, E2, MIN(F2, D2))

 

Note:  Some languages use semicolon (";") to separate parameters instead of comma (",").

 

Thanks Joe, you helped me solve the puzzle