I am trying to use check box to display cell text in Q23 or Q24 (depending on what is checked) in cell B23 but it only displays #VALUE!
formula in cell B23
=IF(P23=TRUE,Q23," ")+IF(P24=TRUE,Q24," ")
Thanks for your help!
I am trying to use check box to display cell text in Q23 or Q24 (depending on what is checked) in cell B23 but it only displays #VALUE!
formula in cell B23
=IF(P23=TRUE,Q23," ")+IF(P24=TRUE,Q24," ")
Thanks for your help!
You cant add spaces only numbers
If either of those conditions ends in a space youll get a #value! error
Change it to
=IF(P23=TRUE,Q23,0)+IF(P24=TRUE,Q24,0)
or
=(P23=TRUE)*Q23+(P24=TRUE)*Q24
or even
=P23*Q23+P24*Q24
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
I tried all three, still getting #VALUE! OR 0 on the first one.
Maybe:
=IF(P23=TRUE,Q23,IF(P24=TRUE,Q24,""))
Or maybe:
=IF(P23=TRUE,Q23,"")&IF(P24=TRUE," "&Q24,"")
That worked estige
Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks