IF FUNCTION

[Zan_Hanifee]

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 - 

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

.

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 · Accepted 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.

[#3]

Thank you so much sir.