Adding two non-adjacent cells (number and text)
Solved/Closed
dkayeh1
Posts
24
Registration date
Monday November 2, 2015
Status
Member
Last seen
December 4, 2015
-
Nov 12, 2015 at 12:16 PM
dkayeh1 Posts 24 Registration date Monday November 2, 2015 Status Member Last seen December 4, 2015 - Nov 13, 2015 at 10:08 AM
dkayeh1 Posts 24 Registration date Monday November 2, 2015 Status Member Last seen December 4, 2015 - Nov 13, 2015 at 10:08 AM
Related:
- Adding two non-adjacent cells (number and text)
- If two cells match return value from third excel ✓ - Excel Forum
- Conditional formatting if cell contains text - Excel Forum
- How would you change all cells containing the word pass to green - Excel Forum
- If cell contains specific text then return value in another cell ✓ - Excel Forum
- Conditional formatting if two cells match ✓ - Excel Forum
1 response
BrianGreen
Posts
1005
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
September 30, 2021
150
Nov 12, 2015 at 04:51 PM
Nov 12, 2015 at 04:51 PM
Hi dkayeh1,
Im not an Excel expert, but to me it seems that you are treating words as if they were numbers in the final bit of your code. The final bit of code I am talking about is ...
It looks to me as though you are adding "na" to "n/a" (or something like that). Have you forgotten to make the cells B341 and B346 at this point?
I hope this is a good enough explanation of what I mean ...
Also, as far as I can remember you are only allowed 7 nested "IF" statements. Im not sure if it counts the first "IF" in that 7, but it might be worth looking at. I see 8 "IF"s in your expression.
Good Luck.
Please let us know how you get on.
I really appreciate thank you messages as a payment for solving issues :o)
Im not an Excel expert, but to me it seems that you are treating words as if they were numbers in the final bit of your code. The final bit of code I am talking about is ...
... ('PILOT Data'!C341>=0,'PILOT Data'!C346>=0),'PILOT Data'!C341+'PILOT Data'!C346,IF('PILOT Data'!C341="",0+'PILOT Data'!C346,IF('PILOT Data'!C346="",0+'PILOT Data'!C341))))))))
It looks to me as though you are adding "na" to "n/a" (or something like that). Have you forgotten to make the cells B341 and B346 at this point?
I hope this is a good enough explanation of what I mean ...
Also, as far as I can remember you are only allowed 7 nested "IF" statements. Im not sure if it counts the first "IF" in that 7, but it might be worth looking at. I see 8 "IF"s in your expression.
Good Luck.
Please let us know how you get on.
I really appreciate thank you messages as a payment for solving issues :o)
Nov 12, 2015 at 05:02 PM
Since this was just frustrating to me I went ahead and set a data validation for the cells and made it to where people inputting data had to put a number in the cell or leave it blank and then I just used a simple sum formula
Again thank you for your help
Nov 12, 2015 at 05:05 PM
Nov 12, 2015 at 05:16 PM
Nov 12, 2015 at 05:28 PM
Nov 12, 2015 at 05:49 PM