How do I get rid of "the formula uses a boolean instead of a number", using the following formula. Better phrased, how do I rewrite the formula to get rid of the warning. Basically, I want $0 to show in a cell G9 if cell B9 is blank, but if any $ amount is put in B9, I want cell G9 to show $275.
IF(B4:B17>0,VALUE(275))+IF(FALSE,VALUE(0))
Mac mini, iOS 12
Hi Nel
You wrote:
IF(B4:B17>0,VALUE(275))+IF(FALSE,VALUE(0))
In G4, revise to:
IF(B4>0,275,0)
Click the green check to confirm the formula.
With the cell still selected, place the mouse pointer near the bottom edge of that cell.
A Fill control (yellow circle) will appear at the center of the bottom edge of the cell.
Click and hold on the fil control, and drag down the column to fill the formula into the rest of the rows in column G.
Regards,
Barry
Hi Nel
You wrote:
IF(B4:B17>0,VALUE(275))+IF(FALSE,VALUE(0))
In G4, revise to:
IF(B4>0,275,0)
Click the green check to confirm the formula.
With the cell still selected, place the mouse pointer near the bottom edge of that cell.
A Fill control (yellow circle) will appear at the center of the bottom edge of the cell.
Click and hold on the fil control, and drag down the column to fill the formula into the rest of the rows in column G.
Regards,
Barry
Worked like a charm!!! Thank you.
How do I get rid of "the formula uses a boolean instead of a number" ?
