separately

I have three columns: I am trying to say: If column B2 has a date then it should be subtracted by A2 but if B2 does not have a date then it should be subtract by today I know the formulas separately but i cant seem to put them together =TODAY()-A2)) = If(Isblank(B2), " ", A2-B2)

Hi guys, I have a huge budget sheet that I use formulas to update data from queries rather than vba to update each cell (shaves a minute or two off the updates) Here's my issue. I need this sumifs to work on the page but the two criteria don't work together and they should. Separately they...

Dear Experts, I have a range of currencies in a single column, I want to have totals currency wise separately. the example values are given below. I want the 3 currencies totals separately in another column. <colgroup><col></colgroup><tbody> GBP 428.00 GBP 264.11 GBP...

What would the formula be for the following, in using conditional formatting (to determine cell to format). I can't seem to use both in the same rule. I even tried doing them separately in their own rule but no go. Here is my statement ... Greater than 1 (>1) but Less than 10 (<10). Exactly...

Good morning, I wonder which command I should employ to copy -from column "L"- the first, and then separately the second, of two cells containing the same text string "Cboe CXE". Thank you.

In Excel 2016 is there any way to put multiple data item's into 1 cell and format them differently or do you have to put the data into separate cells if you want to format each one differently?

Hi, I have a spreadsheet with a bunch of image URLs (A2:A1550). The URL format is domain.com/blah/123456.jpg or domain.com/blah/123456.png The numerical part varies (image names are different). I want to save all the images to a local folder, let's say C:\Temp using the name after the last /...

I have a formula to put a time and time in a cell but it changes every time I do something in the spreadsheet. looking for one that does static time and date and also formula that does static date and time separately. Anybody know how to do this? appreciate any help! Thanks!

Hello, Please i need your help anyone. I have a multiple sheet containing transactions from different client and a colum showing revenue for each of this client. I will like to get the total per client on each sheet separately.

Hello everyone, I don't know if I post to correct forum but I wanted to ask if there is an easy way to merge xml files? I got over 600 xml files which have same structure and splitted because of the file size. But as you know processing each and every one of them separately will take some...

Our spreadsheet names remain constant from year to year. In the past we were able to add an open separately to the right click option and have the ability to open both spreadsheets at the same time without an error. Does anyone know if this can be done in 365 or if there is a quick work around?