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

Skyhook

New Member
Joined
Apr 8, 2002
Messages
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
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
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 :cool:.

Aladin
This message was edited by Aladin Akyurek on 2002-05-11 09:56
 
Upvote 0
Skyhook, (with respect for Aladin's post), here's another option for future reference-

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

Forum statistics

Threads
1,213,536
Messages
6,114,215
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top