Help needed with if( formula giving a value in one cell based on two other cells.

[dancor31]

I am trying to figure out how to achieve the following in spread sheet am working on. I would like one cell to represent a value based the values of two other cells.

1. if I10=4 then K9 should be the value of I9+1

2. otherwise, K9 should reflect the value of I9


I can't seem to find the correct formula for this in Excel. any help would be greatly appreciated.

[Ace_XL]

In K9

=I9+IF(I10=4,1,0)
or
=IF(I10=4,I9+1,I9)
or
=I9+(I10=4)

[dancor31]

thanks for the reply. These don't seem to work for my situation.

[Ace_XL]

thanks for the reply. These don't seem to work for my situation.

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[dancor31]

Here is the attachment as requested:

the first tab shows what I have done. The second what the end result should.

[Ace_XL]

The double quotes convert the number to text. Get rid of them.
Change your formula in I10 to this

=IF(G10=0,0,IF(G10<=0.25,1,IF(G10<0.5,2,IF(G10<0.75,3,4))))

Then in K9, use any of the formulas suggested in Post#2

[dancor31]

Works great!!! Thanks for you help.