Home |
Search |
Today's Posts |
#1
|
|||
|
|||
if(b2=1,b3,0) is this correct
Many years ago, i created a spreadsheet with Lotus with 26 columns, one for
each income or expense, I used a boolean if formula, but forget how to do it. Help? Only positive answers please. Nothing fancy!. |
#2
|
|||
|
|||
=IF(AND(B2=1,B3-0),"Correct","Not")
-- HTH RP (remove nothere from the email address if mailing direct) " wrote in message ... Many years ago, i created a spreadsheet with Lotus with 26 columns, one for each income or expense, I used a boolean if formula, but forget how to do it. Help? Only positive answers please. Nothing fancy!. |
#3
|
|||
|
|||
Hi!
if(b2=1,b3,0) is this correct Yes, the syntax is correct. Here's what it means: The cell in which this formula resides will return the value from cell B3 if the value in cell B2 equals 1, otherwise, it will return 0. Biff -----Original Message----- Many years ago, i created a spreadsheet with Lotus with 26 columns, one for each income or expense, I used a boolean if formula, but forget how to do it. Help? Only positive answers please. Nothing fancy!. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Export auto correct dictionary | Excel Discussion (Misc queries) | |||
How do I select the correct record? | Excel Discussion (Misc queries) | |||
Correct formulas in cells, have to retype to work | Excel Discussion (Misc queries) | |||
pmt function in Excel does not return correct monthly payment amou | Excel Worksheet Functions | |||
Previous Post - Correct Syntax Query | Excel Worksheet Functions |