ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I enter a conditional formula? (https://www.excelbanter.com/excel-worksheet-functions/183965-how-do-i-enter-conditional-formula.html)

Kel

How do I enter a conditional formula?
 
I have never entered a formula before and can't figure it out with the help
menu. I want to enter a formula such that if column B = Project Manager then
column J = 20.00 or if column B = technical coordinator then colmn J = 10.00.
I have about eight things column B could equal to make column J
automatically put in a number.

Teethless mama

How do I enter a conditional formula?
 
Take a look a VLOOKUP function in Help menu


"Kel" wrote:

I have never entered a formula before and can't figure it out with the help
menu. I want to enter a formula such that if column B = Project Manager then
column J = 20.00 or if column B = technical coordinator then colmn J = 10.00.
I have about eight things column B could equal to make column J
automatically put in a number.


ryguy7272

How do I enter a conditional formula?
 
See this
site:
http://www.contextures.com/xlFunctions02.html

Regards,
Ryan---


--
RyGuy


"Teethless mama" wrote:

Take a look a VLOOKUP function in Help menu


"Kel" wrote:

I have never entered a formula before and can't figure it out with the help
menu. I want to enter a formula such that if column B = Project Manager then
column J = 20.00 or if column B = technical coordinator then colmn J = 10.00.
I have about eight things column B could equal to make column J
automatically put in a number.



All times are GMT +1. The time now is 09:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com