All Questions
158
questions
0
votes
0
answers
29
views
IF V16 is greater than 0, does S5=D17? True do nothing, False highlight
I want to get a cell to highlight is the value in cell V16 is greater than 0. I then want it to check if S5=D17. If this is True, no action is required. But if it is False, I want it to highlight.
=IF(...
0
votes
0
answers
75
views
VBA - change cell formatting based on another cell's format
How to change cell formatting based on another cell's format?
I tried the following code:
Range("A9:A9").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.FormatConditions.Add ...
- 1
-2
votes
3
answers
58
views
Excel nested IF function [closed]
I'm having trouble with a nested IF function. I want to assign a "T" value to a cell based on its number value between a Max and Min number. The number resides in cells within Column H. ...
- 169
0
votes
2
answers
54
views
IF Function 2 outcomes
I have a meeting reading sheet with opening and closing readings where I have a simple formula subtracting the closing from the opening to give a consumption reading. I need to add a purchases column ...
-3
votes
1
answer
76
views
if excel formula true false function
i am trying to use the if function in excel but i am stuck.
if cell d7 has text "working" leave blank, if any other text put an X in the cell.
Can anyone help with the correct formula please....
- 13
1
vote
0
answers
2k
views
Last Modified Date formula in Excel that updates when a specific cell value changes (from non-blank)
Excel data set with formula
Please see the attached image of my spreadsheet for reference.
I am trying to build a better version of the formula: =IF(B3<>"",IF(D3<>"",D3,...
0
votes
0
answers
39
views
Excel bugs in formula
I can't use the IFS formula in EXCEL.
The formula is?
=SES(X2>=Concluído;Concluído;X2>=Concluído/Em Validação Controles;Concluído/Em Validação Controles;X2>=Concluído/Em Validação Rev. ...
- 1
0
votes
0
answers
43
views
IF statement to Round values and ignore those with "<"
I have a column of data that has numerical values to two decimal places and also a few values of <0.06. How do I round the values with two decimal places and only return the value of <0.06 ...
- 1
0
votes
2
answers
35
views
IF and or Formula in Excel 2019
=IF(OR(Database!M4="male",Database!M4="female"),Database!MB4,"")
The Result shows me zero (0) I want to, if the cell has no data the result should be blank (empty) not ...
- 3
0
votes
2
answers
30
views
IF formula in excel 2019
The below formula works properly but for the empty cells, it returns #value!
=IF(S4=0," ",IF(E4-S4>=3,"improved",IF(E4-S4<=4,"Not Improved")))
I want the S4 and E4 ...
- 3
1
vote
1
answer
38
views
Range between Percentages in Excel
Condition:
\<10000 = 0%
Between 10000 and 20000 = 5%
Greater than 20000 = 20%
Formula so far:
=IF(B2\>20000,"10%",
IF(AND(B2\>=10000,B2\<20000,"5%"),...
- 11
0
votes
2
answers
323
views
How to use "if statement" in a formula?
Amount
Payment model
100
Yearly
6
Monthly
In the 3rd column, I wish to introduce a formula which will automatically read the entry in column "Payment Model".
If the entry is, "Yearly&...
- 1
0
votes
1
answer
134
views
Insert formula to cell A3 based on a value of A1 in MS Excel?
Dears,
let us say, I have number 1 in A1 in MS Excel.
I am running an IF statement in A2, BUT in case of "TRUE" validation, I want the A3 cell get inserted with a formula or value,
instead ...
- 1
0
votes
3
answers
690
views
Xlookup with dates and sum formula in EXCEL
I am trying to figure out a formula to find the sum of hours worked for each worker per month and also per project. I am pretty sure the XLOOKUP, AND/IF, and SUBTotal could be useful but I am not ...
0
votes
1
answer
132
views
Sum the values of a cell in Excel or change to a different expression of that value in another cell
I have a cell of a worksheet with a value of
1h 25m
entered with the cell (got it from a Jira import). I am trying to figure out how to populate another cell on the same row with a purely numerical ...
- 25