SOLVED

# IF FUNCTION

Super Contributor

# IF FUNCTION

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?

Here is a attached file...

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

# Re: IF FUNCTION

@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.

# Re: IF FUNCTION

Thank you so much sir.