If cell value > 39 do calculation, otherwise return the cell value

[Barking_Mad]

This works fine, but if F15 contains text, the output cell gives a value error. How can I amend so it returns the text value?

=IF(F15>39,G15/2,F15)

[JohnTopley]

Try

=IF(ISNUMBER(F15),IF(G15/2,F15),F15)

[leelnich]

I think John meant:

=IF(ISNUMBER(F15),IF(F15>39,G15/2,F15),F15)

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

[JohnTopley]

Good catch!!!

[Phuocam]

=IF(F15>39,IF(ISNUMBER(G15),G15/2,G15),F15)

[Barking_Mad]

Super! Thanks muchly

[Barking_Mad]

I have a similar problem, and rather starting another thread I thought Id add it here. The following works:

=IF(AND(G16>39,I16=30,M16="NAME"),SUM(H16,L16),"")

But only when G16 and I16 are numbers, not text. When they are text it does the sum (H16,L16) regardless. Can the solution given in post #3 be altered to work in a similar way?

[leelnich]

Try this:
=IF(AND(N(G16)>39,I16=30,M16="NAME"),SUM(H16,L16),"")

or this (similar to post#3):
=IF(AND(ISNUMBER(G16),G16>39,I16=30,M16="NAME"),SUM(H16,L16),"")

[JohnTopley]

Try

=IF(AND(ISNUMBER(G16),ISNUMBER(I16)),IF(AND(G16>39,I16=30,M16="NAME"),SUM(H16,L16),""),"")