vongypsy -
Jul 2, 2009 at 02:44 PM - Latest reply:
rizvisa1

- Posts
- 4481
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- January 6, 2016

- Excel "IF" formula problem
- How to copy data from one sheet to another in excel using formula » How-To - Excel
- Excel basic formulas » How-To - Excel
- Excel grade formula » How-To - Excel
- Excel hide formula bar » How-To - Excel
- How to copy data from one cell to another in excel using formula » Forum - Office Software

Best answer

mubashir aziz

- Posts
- 191
- Registration date
- Sunday April 12, 2009
- 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 ....

mubashir aziz

- Posts
- 191
- Registration date
- Sunday April 12, 2009
- 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
- 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
- 4481
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- January 6, 2016