trevor3007

  1. Trevor3007

    if cell > 0

    hi, Any one have the formula so if a cell > 0, then that cell -30 but if that cell is empty dont display anything? I know if I used =if(a1>0,a1,"") that works, but when I add the -30 it either displays -30 or #value can someone sort me out? KR Trevor3007
  2. Trevor3007

    dates not equal

    hi, Does anyone have the magic formula for this critera/issue:- if the date in a2 does not match the date in a2, then a2 many thanks in advance... KR Trevor3007
  3. Trevor3007

    input box

    hi, i need to create a input box so when the user puts the text into, it will place the text in d1 on sheet 2 I am able to do the above only on sheet 1 . Can anyone help? KR Trevor3007
  4. Trevor3007

    retain date

    Hi, I use the the code below:- =IF(G2="y",TEXT(TODAY(),"dd/mm/yyyy"),"") which work great until the next day, when yesterdays day is now the present day. Is there a way to retain the original date ? Many thanks in advance. KR Trevor3007
  5. Trevor3007

    if/and

    hi, I need to set a criteria so if A1>0 and c1="control" then e1 =1 Thinking it would be:- =if(a1>0,and(c1="control",1,"")) but that does not work ;{ thank you for your help. Trevor3007
  6. Trevor3007

    outlook

    hi, Does any know how to add the subject line into email body, rather than copy & paste into ? Hoping someone can 'rescue me' & thank you for your help. KR Trevor3007

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