Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
blablabla
blablabla asked in Computers & InternetProgramming & Design · 1 decade ago

Excel statement (IF statement)?

so my problem is building an if statement formula using the following data:

A1 B1

Net Income before Taxes 1925

Taxes 751

Net Profit (Loss) 1174

So what i want to do is the following... if Net Income is <0 (less than 0) then I dont pay taxes, therefore Net Profit is = Net Income (equal to net income)

what i had in mind was =IF(B2<0,"B2=B4","B2+B3")

but its not correct because well.. its not working.. so.. help please? :'(

thanks a million!

3 Answers

Relevance
  • jehen
    Lv 7
    1 decade ago
    Favorite Answer

    What cell is this fomula going in?

    Assuming:

    B2 is net income

    B3 is taxes

    B4 is net profit/loss and you are calulating B4

    The fomula in B4 would be =IF(B2<0, B2,B2-B3)

  • Ray
    Lv 7
    1 decade ago

    Try this instead:

    =if(b2<0,b2,b2-b3)

  • Anonymous
    1 decade ago

    remove the quotes

Still have questions? Get your answers by asking now.