Where is my hammer? I'll fix this problem.(Formula) (Resolve

Skyhook · May 11th, 2002, 10:00 AM

Can someone help me with the following problem? It has been eating my lunch for the past couple of days.

In J10 I have =J9+I10 I need this to only work if I9 is >0 otherwise it would show the value of J9. I10 also has a formula of =IF(V10-V9 <0, "0", V10-V9).

Thanks in Advance.

Thanks for all the help

[ This Message was edited by: Skyhook on 2002-05-13 06:42 ]

Aladin Akyurek · May 11th, 2002, 10:10 AM

In J10 I have =J9+I10 I need this to only work if I9 is >0 otherwise it would show the value of J9. I10 also has a formula of =IF(V10-V9 <0, "0", V10-V9

In J10 enter:

=SUM(J9,(I9>0)*I10)

Change your formula in I10 to:

=MAX(0,V10-V9)

IF is not always the best thing to use

.

Aladin

[ This Message was edited by: Aladin Akyurek on 2002-05-11 09:56 ]

dsnbld · May 11th, 2002, 01:17 PM

Skyhook, (with respect for Aladin's post), here's another option for future reference-

=IF(I9>0,SUM(J9,I10),J9)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 11th, 2002, 10:00 AM	#1
Skyhook New Member Join Date: Apr 2002 Location: East Texas Posts: 38	Can someone help me with the following problem? It has been eating my lunch for the past couple of days. In J10 I have =J9+I10 I need this to only work if I9 is >0 otherwise it would show the value of J9. I10 also has a formula of =IF(V10-V9 <0, "0", V10-V9). Thanks in Advance. Thanks for all the help [ This Message was edited by: Skyhook on 2002-05-13 06:42 ]

May 11th, 2002, 10:10 AM	#2
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,317	In J10 I have =J9+I10 I need this to only work if I9 is >0 otherwise it would show the value of J9. I10 also has a formula of =IF(V10-V9 <0, "0", V10-V9 In J10 enter: =SUM(J9,(I9>0)*I10) Change your formula in I10 to: =MAX(0,V10-V9) IF is not always the best thing to use . Aladin [ This Message was edited by: Aladin Akyurek on 2002-05-11 09:56 ]

May 11th, 2002, 01:17 PM	#3
dsnbld Board Regular Join Date: May 2002 Posts: 206	Skyhook, (with respect for Aladin's post), here's another option for future reference- =IF(I9>0,SUM(J9,I10),J9)