Which formula/function is needed for this?

[DanielJHughes]

The formula/function will be in the cell below LM (015) I want it to make a caluclation depending on what Part Number is in J15. For example, =IF(J15="1735",((N15*N15)-($S$7*$S$7))/($R$7*1.273),"")

Calculation.jpg

Thank you very much!

[udprocks]

=IF(J15="1735",((N15*N15)-($S$7*$S$7))/($R$7*1.273),"")


is that your given example formula is working correctly for you?

[DanielJHughes]

=IF(J15="1735",((N15*N15)-($S$7*$S$7))/($R$7*1.273),"")


is that your given example formula is working correctly for you?

It works for 1735 yes, but I need it to work for all of them

[udprocks]

It works for 1735 yes, but I need it to work for all of them

then try it may be it make sense.

=IF(J15=J15,((N15*N15)-($S$7*$S$7))/($R$7*1.273),"")

[JohnTopley]

Try

=IF($J15<>"",IFERROR((($N15^2)-VLOOKUP($J15,$Q$6:$S$200,3,0)^2)/(VLOOKUP($J15,$Q$6:$S$200,2,0)*1.273),""),"")


Make sure the you have consistent data types: J15 is Text, entry in Q7 is numeric: I had to renter it for the formula to work

[DanielJHughes]

Try

=IF($J15<>"",IFERROR((($N15^2)-VLOOKUP($J15,$Q$6:$S$200,3,0)^2)/(VLOOKUP($J15,$Q$6:$S$200,2,0)*1.273),""),"")


Make sure the you have consistent data types: J15 is Text, entry in Q7 is numeric: I had to renter it for the formula to work

Had to re enter what? Some works some doesn't, thanks for the help.

EDIT: Got it working, thanks!

[JohnTopley]

If your problem has been solved, could you mark the thread as such ("Thread Tools" at top of fist post).

Thank you.