Home |
Search |
Today's Posts |
#1
|
|||
|
|||
What does "," mean in a formula?
This is the formula put together and I was wondering if anyone knew what the
comma in between the quotations meant. Could you explain what the formula means? Thanks a bunch. =IF(D16="","",D16) |
#2
|
|||
|
|||
If D16 is nothing (empty), then return nothing, otherwise return the value in
D16. HTH Jason Atlanta, GA "Excel Question" wrote: This is the formula put together and I was wondering if anyone knew what the comma in between the quotations meant. Could you explain what the formula means? Thanks a bunch. =IF(D16="","",D16) |
#3
|
|||
|
|||
Hi!
The comma is simply an argument separator. The function is IF. The IF function uses 3 arguments and the arguments are separated by commas. =IF Argument 1 is D16="". Meaning D16 = blank The first argument in an IF function is a logical test. That is, is this condition TRUE or FALSE. Argument 2 is "". Meaning blank. The second argument in the IF function is the value to return if the logical test is TRUE. Argument 3 is D16. Meaning the value in D16. The third argument in the IF function is the value to return if the logical test is FALSE. Put it all together: IF D16 = blank, return blank, return D16 Biff "Excel Question" wrote in message ... This is the formula put together and I was wondering if anyone knew what the comma in between the quotations meant. Could you explain what the formula means? Thanks a bunch. =IF(D16="","",D16) |
#4
|
|||
|
|||
In that case, why not jsut make the cell =D16?
Jason Morin wrote: If D16 is nothing (empty), then return nothing, otherwise return the value in D16. |
#5
|
|||
|
|||
If D16 is empty, then the formula =d16 will return a 0.
JoOwl0 wrote: In that case, why not jsut make the cell =D16? Jason Morin wrote: If D16 is nothing (empty), then return nothing, otherwise return the value in D16. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |