The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
14 views

Excel cell value (text) based on 2nd cell value (number) appearing in a named range

I have a spreadsheet where I want a contact name to appear in a cell (F166) if the department number (P166) appears in a named range ("PS Depts" on Sheet2). Here is my existing formula, but it only ...
2
votes
1answer
31 views

IF and then condtional format

In Column C, I Want to rename the Column A Name in order of Date Of Birth, but only if a duplicate is found. Otherwise, the name in Column C should be the same as Column A. For example, there are ...
0
votes
0answers
11 views

assign string “tags” based on numeric interval in Libreoffice Calc

I'm struggling with an easy issue. I'm working in Libreoffice Calc and I have a numeric column with values from 0 to 365. What I would like to do is to create another column assigning string values ...
0
votes
1answer
29 views

AVERAGEIF based on formatting

I am using Microsoft Excel 2010. I would like to do an AVERAGEIF, with the criteria based on formatting. Ex: For cells, I choose A1-A3. A1 is the percentage value 10%. A2 is the number value 20. ...
0
votes
2answers
65 views

Excel - Compare two cells and display the larger number?

Can someone tell me how to compare two cells (numbers), and then display the larger cell? Cell C1 = IF A1 > B1 then display A1 else display B1 Sorry I'm not an excel pro.
0
votes
1answer
73 views

Excel (how to use if then else for the following condition)

cell 1>cell 2,cell 1<cell 4 print the value in cell 3 cell 1<cell 2,cell 1<cell 4 print the value in cell 4 cell 1>cell 2,cell 3<cell 2 print the value in cell 2 how to use these ...
1
vote
1answer
17 views

Odd issue with OR operator in zsh

I'm seeing an odd issue with CentOS 6.4, zsh 4.3.10 (x86_64-redhat-linux-gnu). This is running two regular expressions on the same string. Neither expression passes the if conditional, but when I OR ...
0
votes
1answer
290 views

Excel: formula to fill text data from sheet based on condition?

So, here's the situation. I have a workbook with several sheets. I've got one with a list of companies and their data (Tax ID, address, city, etc.) and another - working one. I have a cell with a ...
0
votes
1answer
284 views

SUMPRODUCT and IF conditional (LibreOffice) [closed]

I would like to multiply two cells in a same row, if a condition of a third adjacent cell is met; then sum the result to the next product in the next row (if condition is met), and so on. | A | B ...
4
votes
1answer
93 views

Batch File IF Statement Time Taken

I am trying to write a batch file that takes the time taken of a command and converts it into hours, minutes and seconds. Here's what I've got: @echo off set /a sec=0 set /a min=0 set /a hrs=0 for ...
0
votes
1answer
93 views

I'm trying to run a batch file that test for 4 different files then based on the correct file present it runs the correct command

:: batch file to run backup @echo off setlocal set backup1=="F:\my backups\Disk_1_DataBAckup" set backup2== "F:\My backups\2_backup_data_to_disk2" set backup3=="G:\my backups\3_backup_data_to_disk3" ...
2
votes
1answer
149 views

Bash script that execute command only if port is free

Hi I have a bash script that needs a conditional execution of a few lines of code based on whether port 80 is already in use: sudo git fetch origin; sudo git checkout master; sudo git pull; --- if ...
1
vote
1answer
77 views

what does =~ in linux means used in if condition to compare values

Actually tomcat/conf/catalina.properties file contains line shared.loader=/usr/share/sfit/conf I mean value has some path. so using shell script we are updating shared.loader values in file. And also ...
0
votes
1answer
84 views

Delete files which have almost identical filenames EXCEPT last word (Windows)

I'm trying to sort a directory of files with some conditions but I can't for the life of me figure this out. Here's a little example of some filenames which are to be sorted out (deleted). Turok 3 - ...
0
votes
2answers
80 views

How can I return a list of specific words found in a cell's contents?

I have two columns, one with a string of text (A1), the other blank (A2). A1 looks something like this: "Briefs on Southern Africa, Rhodesia, East of Suez (Including Soviet Naval Expansion), ...
1
vote
1answer
88 views

How do I write a conditional assignment in a Linux script?

I need to create a formula in a Linux shell script. If this was DOS, I'd (probably) be fine, but I've made the change and need to learn....! D1 = a 5-digit number between 40500 and 49500 (this is ...
0
votes
1answer
302 views

IF evaluation in Field codes checking for last page in Word 2011

I am trying to use the IF field code in Word but I am getting radically unpredictable behavior. My syntax is this: {IF PAGE = NUMPAGES "YES" "NO"} I have inserted it into a footer, text box, ...
0
votes
1answer
96 views

Sum of rows conditional on two conditions [duplicate]

I'd like to use array function to get conditional sum based on two columns. Given the example, for each ID I want to calculate the sum of value column if column B is -1 ID | B | value | ...