SOLVED

IF FUNCTION

%3CLINGO-SUB%20id%3D%22lingo-sub-3251225%22%20slang%3D%22en-US%22%3EIF%20FUNCTION%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3251225%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Everyone%2C%3C%2FP%3E%3CP%3EI%20applied%20multiple%20IF%20FUNCTION%20-%26nbsp%3B%3C%2FP%3E%3CP%3E%E2%80%A2%20Less%20than%2030%20age%20-%20200%3CBR%20%2F%3E%E2%80%A2%2030%20-%2040%20age%20-%20300%3CBR%20%2F%3E%E2%80%A2%20More%20than%2040%20age%20-%20500%3CBR%20%2F%3E%E2%80%A2More%20than%2050%20age%20-%20600.%3C%2FP%3E%3CP%3ESo%2C%20if%20a%20person%20enters%20just%20the%20age.%20Then%20the%20amounts%20should%20automatically%20get%20update.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20applied%20this%20formula%20-%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DIF(B2%26lt%3B31%2C200%2CIF(B2%26lt%3B41%2C300%2CIF(B2%26lt%3B51%2C500%2CIF(B2%26gt%3B50%2C600%2C%22%20%22))))%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EAnd%20it%20works%3C%2FP%3E%3CP%3Elike%20-%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%20(6430).png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F354147iE543BD1757F0DAA8%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%20(6430).png%22%20alt%3D%22Screenshot%20(6430).png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20i%20want%20the%20cell%20is%20blank%20so%20it%20should%20be%20blank.%3C%2FP%3E%3CP%3E.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%20(6431).png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F354155i5188CF0158A6FF8E%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%20(6431).png%22%20alt%3D%22Screenshot%20(6431).png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20what%20should%20i%20add%20in%20this%20formula%2C%20the%20cell%20is%20blank%20then%20it%20should%20give%20blank%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20a%20attached%20file...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3251225%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-3251237%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20FUNCTION%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3251237%22%20slang%3D%22en-US%22%3EThank%20you%20so%20much%20sir.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3251232%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20FUNCTION%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3251232%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F811137%22%20target%3D%22_blank%22%3E%40Zan_Hanifee%3C%2FA%3E%26nbsp%3BKeep%20in%20mind%20that%20a%20blank%20cell%20evaluates%20to%20be%20less%20than%2030%2C%20so%20it%20will%20always%20return%20200.%20Test%20for%20the%20blank%20cell%20first%2C%20have%20the%20formula%20return%20a%20blank.%20Otherwise%2C%20execute%20the%20formula.%20File%20attached.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Super Contributor

Hello Everyone,

I applied multiple IF FUNCTION - 

• Less than 30 age - 200
• 30 - 40 age - 300
• More than 40 age - 500
•More than 50 age - 600.

So, if a person enters just the age. Then the amounts should automatically get update.

 

I applied this formula -

=IF(B2<31,200,IF(B2<41,300,IF(B2<51,500,IF(B2>50,600," "))))

And it works

like - 

Screenshot (6430).png

 

But i want the cell is blank so it should be blank.

.Screenshot (6431).png

 

So what should i add in this formula, the cell is blank then it should give blank?

 

Please help.

 

Here is a attached file...

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@Zan_Hanifee Keep in mind that a blank cell evaluates to be less than 30, so it will always return 200. Test for the blank cell first, have the formula return a blank. Otherwise, execute the formula. File attached.

 

Thank you so much sir.