f10

  1. J

    formula from a date in a different cell

    Hello I'm trying to create a work sheet but im stuck on the formula im trying to get my value from H10 which = 2 my cell my formula goes in is I10 my date is in I7 End date is in F10 can I create a formula thats in I10 that looks at a date in I7 and if its less than the date in F10 places a...
  2. G

    Auto fill based on another cell value

    I am not sure if this was asked before. I tried searching, but didn't find any. Maybe I'm searching by wrong keywords. I have an excel sheet where F9 and F10 is blank. When printed on paper, it should show # / #. Imagine Microsoft Word setup with page numbering. Depending on the project we are...
  3. JTL9161

    Conditional Formatting with 3 Conditions

    Trying to write a formula for a 3 condition conditional format. In cell D10: If cell D10 = F10 then fill cell D10 a color. If D10 <> F10 then no color. If D10 is blank and F10 is blank then no color. I will use this down the D column but I am only using 1 row for this example. Appreciate...
  4. R

    multiple if functions in the same cell

    Good afternoon, I am trying to create a formula that "specifically" if cell B22 has a date in it that cell F10 stops adding the date from the previous cell (E10) however if there is a date in B22 then F10 stops counting (this is the easy part I have got this) now if cell C22 does not have a...
  5. H

    AND in formula in conditional formatting not working

    Good Evening everyone, I have two cells, lets say G10 and H10, with a formula (say =G4-(SUM(G6:G9) ) and the second cell is exactly the same formula but referencing the next column. Then in cell F10 I have a formula generating text based on the results of G10 and H10. All these formula are...
  6. R

    If, And, ElseIf, Else Statement Help

    Hello all, back at it again with an easy question for the experts out there. I need the following to happen; If F7 does not equal blank, and F10 does equal blank, then L10 should be filled with the text "3) Remove Shunt" If F7 does not equal blank, and F10 does not equal blank, then L10...

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