ExcelBanter - IF statements

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF statements (https://www.excelbanter.com/excel-discussion-misc-queries/13856-if-statements.html)

Kim

IF statements

Please tell me why the following is not valid?

=IF(B22,[B2^-.10],[B2^.10])

Dave O

The problem is the square brackets: replace them with parentheses or
remove them, and you're good to go.

All times are GMT +1. The time now is 01:51 PM.