Excel 2007 : 'IF' Statement Help...If Value is blank use another

**jesz1987** · 08-17-2011, 04:56 AM

Hi,
After some much needed help please

I need a formula that basically uses a value if its there, but if its not, then use another one.

Spreadsheet goes like this

COL A, COL B , COL C , COL D

34, yes/no, Generates if select yes on COL B , =colC+2 but if blank add2 from COL A

Hope this makes sense, i have done this before but completely forgotten how to do it.
Thanks

PS i have attachted the sheet. Thanks

**Richard Buttrey** · 08-17-2011, 05:13 AM

Hi,

I don't understand. I'll use your actual column letters O,P,Q rather than A,B,C

In which column are you trying to enter a formula? You already have a formula in Q which seems to be doing what you want - I'd leave out the space between the " " but that's a minor comment.

Perhaps an example showing what you want to see would assist.

Regards

**jesz1987** · 08-17-2011, 06:53 AM

Hi,
On the spreadsheet you can see if COL P is input 'Yes', then COL Q generates COL O + 2. If its input 'no' then COL O stays blank.

What i need is, COL R, if COL Q is generated (by inputting Yes in COL P) then i want to use COL Q + 2, but if COL Q is blank (by inputting NO into COL P) i want COL R to generate by using COL O + 2.

Hope this makes sense now lol

Thanks for the reply already
Jez

**Richard Buttrey** · 08-17-2011, 07:08 AM

Hi,

Why not use in R2:

Please Login or Register  to view this content.

Incidentally and as I mentioned last time I'd advise you to change your Q2 formula to

Please Login or Register  to view this content.

i.e. leave out the space character between the quotes. Experience tells me that this trips up many people when analysis and filtering start to become more complex. It's a good habit to get into.

Regards

**jesz1987** · 08-17-2011, 10:35 AM

Cheers, this doesnt work how i want it to, but i just realised i could use that forumla so if its NO i can use O2 +2, i knew it was simple. Thanks for your response mate.
Jez