# Hi I need help making an excel IF formula. Im trying to have if true i need this and if false i need this.?

this is what i currently have but its not working any help will be much appreciated.

=if(B2="C", [=sum(G2+H2)*D2*100] , [=sum(G2-H2)*D2*100])

if whats in B2 is letter C i need [=sum(G2+H2)*D2*100]

if B2 is not letter C "it will actually read as letter P" i need [=sum(G2-H2)*D2*100])

=if(B2="C", [=sum(G2+H2)*D2*100] , [=sum(G2-H2)*D2*100])

if whats in B2 is letter C i need [=sum(G2+H2)*D2*100]

if B2 is not letter C "it will actually read as letter P" i need [=sum(G2-H2)*D2*100])

Follow

4 answers
4

Are you sure you want to delete this answer?