g11

  1. A

    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. S

    Work in progress and work completed

    Cell B2= Todays Date Cell B11= Start Date Cell C11 = End Date Cell D11= Days Remaining At present cell d11(gives the value of end date of the task - todays date (c11-b2) What I want to do is if the task is completed then cell g11 will have a 0 (implying task completed) and cell d11 will no...
  3. R

    Getting excel to ignore blank cells when using IF AND function

    Hi This is my function, but I need it not to calculate anything when one of the cells is blank (either E11 or G11). How would I do this please? =IF((AND(E11<=50, G11="Proficient")), "Yes", "No") Thanks!
  4. N

    Need help with loops

    Hey All, I have a code that calls another part of the code that basically draws arrows. But I want the code to look at another sheet called "Task Name" and only at columns to get the From and To cell locations to help draw the arrows. Task Names From To Task A E11...

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