New to If Function

[Lou1238]

I am trying to do a simple Invoice for the wife's business. I have searched many sites but have not found what I needed. I need to know if there is a way to use the IF function for an entire column. Basically If column B is Note then column E is $2, If column b is Letter then column E is $3.
I have found how to do individual rows but not the whole columns.

[Jul Stev]

=IF(B2="Note",2,IF(B2="Letter",3,0))

you mean like this? try to copy the formula through all cell in column E as needed and format the column using dollar sign.

[:) Sixthsense :)]

if there is a way to use the IF function for an entire column

=IF(COUNTIF(B:B,"Note"),2,IF(COUNTIF(B:B,"Letter"),3,""))

Format the Formula Cell with the $ Currency.

[FDibbins]

Hi and welcome to the forum

Please take a moment to review our forum rules, specifically rule #1 regarding thread tiles. Then please rename this thread to something that more accurately describes your problem...think google terms - if you typed "new to IF functions" into google, what would you expect to get back?

To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title