IF statement - 2 features + action if cell is blank

**rayted** · 10-01-2018, 04:42 AM

Hi guys,

I am providing my weight loss spread sheet here:

https://docs.google.com/spreadsheets...it?usp=sharing

I have a formula

=IF(K22>J22,"you have put on weight this week, try to get back on track next week!",IF(K22<J22,"you have lost weight this week, keep it up!",""))

I want to add something that says if cell K22 is blank, then return: You have not input a target! Can someone help me with adding this to my formula above please?

Thank you!

**Pete_UK** · 10-01-2018, 04:51 AM

Hi Ray,

Try this:

=IF(K22="","You have not input a target!",IF(K22>J22,"you have put on weight this week, try to get back on track next week!",IF(K22<J22,"you have lost weight this week, keep it up!","")) )

Hope this helps.

Pete

**rayted** · 10-01-2018, 05:00 AM

Appreciated Pete, works a charm!

**Pete_UK** · 10-01-2018, 08:23 AM

You're welcome. Note that the final "" will only occur if the two weights are the same for consecutive weeks, so you could put something like "no change this week" rather than have it blank.

Pete

IF statement - 2 features + action if cell is blank

LinkBack

Thread Tools

Rate This Thread

Display

IF statement - 2 features + action if cell is blank

Re: IF statement - 2 features + action if cell is blank

Re: IF statement - 2 features + action if cell is blank

Re: IF statement - 2 features + action if cell is blank

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] If Statement when Cell is not Blank

[SOLVED] Blank Cell - IF Statement

[SOLVED] If cell a2 is blank if statement

If statement on blank cell

IF Statement to leave cell blank if multiple cells are all blank

[SOLVED] Do more than on action if and IF statement is true

[SOLVED] If statement that copies text from a separate worksheet, or if blank, leaves cell blank.

Bookmarks

Bookmarks

Posting Permissions