# i11

1. ### IF Formula

Hi, I am trying to get a formula to return one of three values for two cell, I have two cells (i.e. F11 and G11) if F11 has something in, I need cell I11 to return "In Progress" if G11 contains something then I11 to return "complete"... at this point, both F11 and G11 would have something in...
2. ### This formula works I need some spaces

I need 5 spaces after the 4" part of the formula. The formula is working except for not having the spacing =IF(K11=0,I11 & "\$"&TEXT(AH11,".00")&"/Qty",AH11&"/lf")
3. ### Having Issues With Conditional Partial Vertical Column Sums Based On Date Ranges

:eek: https://imgur.com/a/G6LurIo Hello Folks. Hoping someone can assist with this dilemma. The image linked herein shows what the spreadsheet looks like. How would I write formulas in cells I11, J11, K11, and L11 such that they all reference the entered start and end dates in cells J5 and...
4. ### Action status between two dates

Sorry for reposting... seems like I can't edit yet. I have 3 cells. Cell I11 | Cell J11 | K11 Proposed completion date | Actual Completion Date | Action Status What I want to do is have a formula that detects: when I11 is not blank and J11 blank = open when I11 is not blank and J11 is not...
5. ### Aa

Hi, I have 3 cells. Cell I11 | Cell J11 | K11 Proposed completion date | Actual Completion Date | Action Status What I want to do is have a formula that detects: when I11 is not blank and J11 blank = open when I11 is not blank and J11 is not...

### 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?

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