IF Formula (and, I'm not sure this is the correct Formula?)

[connman]

What I'm trying to do:

• I have a Cell that has a Number in it.
• I have a Cell that has a Formula in it.
• I'd like to have the Number Cell (Cell #1) be Greater Than and override/default from the Formula Cell (Cell #2) when applicable (otherwise it defaults to the higher value of the two).
• I'd like it to return/total a Number.
• Here's what I have: =IF(I8>(D8*I5)+J5,"I8")
• Note:
  • I8, J5, and J8 are Formula Cells.
  • D8 is a Number Cell.

Any help would be appreciated.

Thank you in advance.

 

[Joe4]

Welcome to the Board!

Your explanation is a bit confusing. I think it would be beneficial if you could post a few different scenarios (with real values), in which you tell us what the values are in cells I8, J5, J8, and D8, and tell us what your expected result is in each situation.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[Dave Patton]

consider either of the following and/or provide sample data with the forum's tool named XL2BB.

T202308a.xlsm
	J
8	15
9	15
3e

Cell Formulas
Range	Formula
J8	J8	=IF(I8>(D8*I5)+J5,I8,(D8*I5)+J5)
J9	J9	=MAX(I8,D8*I5+J5)

 

[connman]

I downloaded the App, but I can't seem to Upload a Mini-sheet. Here's a Pic in the meantime.

 

[connman]

The "=IF(I8>(D8*I5)+J5,I8,(D8*I5)+J5)" worked PERFECTLY! Thank you!

 

[connman]

OK. So, I separated 3 Formulas to Test. And, with the help of the above , I was able to have all 3 Test positively. However, when I put them all together, the Formula doesn't work.

Here it is:

=1*(D8+(D8/0.89-D8)+(=MAX(I8,D8*I5+J5))/0.6

 

[Joe4]

You need to remove the "=" from the middle of your formula:

=1*(D8+(D8/0.89-D8)+(MAX(I8,D8*I5+J5))/0.6

 

[connman]

Hi Joe4,

Thank you!

 

[Joe4]

You are welcome.