Home

Help with a formula

%3CLINGO-SUB%20id%3D%22lingo-sub-774498%22%20slang%3D%22en-US%22%3EHelp%20with%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774498%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%20where%20one%20cell%20has%20a%20calculation%20for%20the%20number%20days%20since%20an%20invoice%20was%20sent%20and%20there%20is%20a%20second%20cell%20for%20the%20number%20of%20days%20since%20a%20revised%20invoice%20was%20sent.%26nbsp%3B%20At%20issue%20is%20that%20there%20isn't%20always%20a%20revised%20invoice%2C%20so%20on%20those%20cells%20where%20there%20is%20no%20date%20for%20the%20calculation%20excel%20is%20attempting%20to%20calculate%20and%20just%20putting%20a%20number%20that%20has%20nothing%20to%20do%20with%20anything.%26nbsp%3B%20Right%20now%20I%20was%20just%20using%26nbsp%3B%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3ETODAY%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E(%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E)%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20%20default-formula-text-color%22%3E-%3C%2FSPAN%3E%3CSPAN%3EG3%2C%20if%20G3%20is%20empty%20the%20number%20appears%2C%20I%20want%20to%20get%20rid%20of%20the%20number.%26nbsp%3B%20Thanks!!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-774498%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-774523%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774523%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F382377%22%20target%3D%22_blank%22%3E%40tinksmama%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(G3%3D%22%22%2C%22%22%2CToday()-G3%20)%3C%2FP%3E%3C%2FLINGO-BODY%3E
tinksmama
New Contributor

I have a spreadsheet where one cell has a calculation for the number days since an invoice was sent and there is a second cell for the number of days since a revised invoice was sent.  At issue is that there isn't always a revised invoice, so on those cells where there is no date for the calculation excel is attempting to calculate and just putting a number that has nothing to do with anything.  Right now I was just using =TODAY()-G3, if G3 is empty the number appears, I want to get rid of the number.  Thanks!!

1 Reply

Hi@tinksmama 

 

=IF(G3="","",Today()-G3 )