False error

- - Latest reply: ac3mark
Posts
12351
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
June 16, 2019
- Apr 22, 2019 at 09:23 AM
Hello,
How to remove false error while using this formula *if(c2="A",sumifs(sheet2!AA:AB,sheet2!B:B,sheet1!B:B, sheet2! Sheet1! A:A))*



System Configuration: Android / Chrome 70.0.3538.110
See more 

1 reply

Posts
12351
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
June 16, 2019
1057
0
Thank you
Place a value for false, before the last ")".... as in:

),"here is the false value")

Syntax for IF is as follows:
If (logictest, true, false)

You have not defined the false value, therefore excel presents FALSE.

Respond to ac3mark