SOLVED
Home

Help with IF function

%3CLINGO-SUB%20id%3D%22lingo-sub-621917%22%20slang%3D%22en-US%22%3EHelp%20with%20IF%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-621917%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20hit%20a%20brain%20block%2C%20I%20should%20be%20able%20to%20do%20this%20but%20I%20can't!%3C%2FP%3E%3CP%3EI%20am%20calculating%20a%20formula%20where%20IF%20the%20cell%20%3D%20%3CSTRONG%3Ethe%20value%20of%20any%20number%20from%201%20through%20to%2010%3C%2FSTRONG%3E%2C%20%3CI%3Ethen%20return%201.5%2C%20otherwise%20return%20a%200%3C%2FI%3E%3C%2FP%3E%3CP%3EIf%20someone%20can%20point%20me%20in%20the%20right%20direction%20that%20would%20be%20great.%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-621917%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-622105%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20IF%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-622105%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F345421%22%20target%3D%22_blank%22%3E%40bdterry%3C%2FA%3E%26nbsp%3B%2C%20This%20should%20do%20it%20%26nbsp%3B%3DIF(AND(A2%26gt%3B%3D1%2CA2%26lt%3B%3D10)%2C1.5%2C0)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-622131%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20IF%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-622131%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F259521%22%20target%3D%22_blank%22%3E%40Rich99%3C%2FA%3E%26nbsp%3B%20yip%20thanks%2C%20got%20it%20sorted%20finally%20and%20then%20your%20message%20came%20through...%20spot%20on!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
bdterry
New Contributor

I have hit a brain block, I should be able to do this but I can't!

I am calculating a formula where IF the cell = the value of any number from 1 through to 10, then return 1.5, otherwise return a 0

If someone can point me in the right direction that would be great.

Thanks!

 

2 Replies
Solution

Hi @bdterry , This should do it  =IF(AND(A2>=1,A2<=10),1.5,0)

@Rich99  yip thanks, got it sorted finally and then your message came through... spot on!

 

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies