IF statements

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please tell me why the following is not valid?

=IF(B2>2,[B2^-.10],[B2^.10])
 
The problem is the square brackets: replace them with parentheses or
remove them, and you're good to go.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If function limitations help 7
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Date and If problem 6
Multiple IF statement not working 5
if statements 3
Report data from cell if dates match 2
help with column text 2
Referencing a cell even if its contents are moved moved/replaced 6

Back
Top