All Questions
Tagged with arguments worksheet-function
5
questions
0
votes
1
answer
549
views
I am trying to make a formula in excel using if blank statement for multiple cells. Possibly two different arguments
My current formula is =IF(ISBLANK(J2),M2*AB2, IF(J2>1, AC2))
Important to note my formula in M2 is =IF(ISBLANK(L2),"",L2-G2)
AB2=250 AC2= 550
The code runs as G2 gets a delivery date ...
0
votes
1
answer
121
views
Excel Conditional Formatting - Using Formula as Part of a Cell Reference
I am trying to use conditional formatting to highlight a cell if it is blank and a cell in the first column of the same row is not blank. For example, if the conditional formatting is for cell D4, I ...
0
votes
0
answers
46
views
Too many arguments with IF (another one!)
I have a very complex set of arguments. I can get my spreadsheet to partially work but not fully and have to use an additional column and make manual adjustments. If anyone could help me just have a ...
2
votes
1
answer
285
views
Why is Excel showing 'c' as the arg separator for fomulas?
In Excel 2007, I have a cell with
"=if(true,1,0)"
as the contents. If I hit the ENTER key
I get an error dialog which says, "The formula you typed contains an error."
The flyover help for ...
0
votes
1
answer
528
views
When switching to another doc, Function Argument window disappears?
I have problem with Excel 2007 when using VLOOKUP function. After switching to another document for referencing value in "Table_array" field, window dissapears.
Google finds some results about the ...