If cell has YES

[darcyfournier]

If A1 has "Yes" then B1= $45

if A1 is Blank, B1 needs to be Blank as well (no value at all)

This will be 250 rows and not every cell with have Yes so I need the value of those cells to be blank

Can anyone help?

Thanks so much

 

[footoo]

https://support.office.com/en-us/article/IF-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2

 

[00jaggy]

For both of the below, $45 will show up as text. If you want it in a number format, change "$45" to just 45 (no quotes) and use the currency formatting in Excel.

This will keep Col B blank for any value not = Yes in Col A
=IF(A1="Yes","$45","")

Alternatively, you can base your formula on whether or not Col A is blank. If it's blank, Col B will be blank. If there is anything at all in Col A (ie. "yes", "x", "no") it will populate Col B with $45
=IF(ISBLANK(A1),"","$45")


Copy and paste down all 250 rows.