Related:

- Excel "IF" formula problem
- Excel @ in formula ✓ - Forum - Excel
- How to copy data from one sheet to another in excel using formula - How-To - Excel
- How To Copy Data from One Excel Sheet to Another Using a Formula - How-To - Excel
- Excel position formula ✓ - Forum - Office Software
- Copying data from one Excel sheet to another. ✓ - Forum - Excel

## 6 replies

mubashir aziz

- Posts
- 190
- Registration date
- Sunday April 12, 2009
- Status
- Member
- Last seen
- February 16, 2010

the problem is occurring because of "" "text" To avoid the "" error you can enter below formula

=IF(SUM(C2,E2:F2)>0,SUM(N(C2)-N(D2)+N(E2)+N(F2)),"")

OR

=IF(SUM(C2,E2:F2)>0,N(C2)-SUM(E2:F2),"")

both will work fine ....

=IF(SUM(C2,E2:F2)>0,SUM(N(C2)-N(D2)+N(E2)+N(F2)),"")

OR

=IF(SUM(C2,E2:F2)>0,N(C2)-SUM(E2:F2),"")

both will work fine ....

vongypsy

Thank you so much, it worked!

May I ask, what does the N mean? I've never seen that before.

=IF(SUM(C2,E2:F2)>0,SUM(N(C2)-N(D2)+N(E2)+N(F2)),"")

May I ask, what does the N mean? I've never seen that before.

=IF(SUM(C2,E2:F2)>0,SUM(N(C2)-N(D2)+N(E2)+N(F2)),"")

joan

I tried doing the same thig by adding all the rows with FT and H but I still keep getting #Value result. What I am doing wrong?

=SUM(IF(($G$6:$G$1476="FT")*($F$6:$F$1476="H"),1,0))

Thanks in advance for your help!

Joan

=SUM(IF(($G$6:$G$1476="FT")*($F$6:$F$1476="H"),1,0))

Thanks in advance for your help!

Joan

mubashir aziz

- Posts
- 190
- Registration date
- Sunday April 12, 2009
- Status
- Member
- Last seen
- February 16, 2010

Here I used N() to convert the text into value "0". Below example will explain remain usage of N()

A2=7 A3=Hello A4=TRUE A5=4/17/2008 Formula Description (Result) =N(A2) Because A2 contains a number, it is returned (7) =N(A3) Because A3 contains text, 0 is returned (0, see above) =N(A4) Because A4 is the logical value TRUE, 1 is returned (1, see above) =N(A5) Because A5 is a date, the serial number is returned (varies with the date system used) =N("7") Because "7" is text, 0 is returned (0, see above)

BEGGGINER

- Posts
- 1
- Registration date
- Tuesday December 8, 2009
- Status
- Member
- Last seen
- December 8, 2009

HI ,I need help with very simple formula that doesent work for me ,I'm not an expert so I tried some advices form this and some other forums but its still giving me error message,help:(

well my formula should look something like this

=IF(D11=1;F5,IF(D11=2;F6,IF(D11>2;0)))

maybe im useing old version but I have to input ; instead of , for the equasion to work,i also tried copy paste from some other posts but it still gives me error meassage ,ctrl+shift+enter dont work either...

is there any other way to do this??

Thanks a lot for help

well my formula should look something like this

=IF(D11=1;F5,IF(D11=2;F6,IF(D11>2;0)))

maybe im useing old version but I have to input ; instead of , for the equasion to work,i also tried copy paste from some other posts but it still gives me error meassage ,ctrl+shift+enter dont work either...

is there any other way to do this??

Thanks a lot for help

rizvisa1

- Posts
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020

Isnt the last If clause missing the value in case of "false" condition, I wonder if that is the reason