# Functions in excel- Help?

Discussion in 'Business Applications' started by TracyAllen, Jul 21, 2005.

Not open for further replies.

Joined:
Jul 21, 2005
Messages:
3
I have windows XP. I am in excel, I have to put a function in. I thought I had it but it is not working. What I want it to do is this....

Week 1

361.00

*
*
*
*
Total

pretend this is an excel spreadsheet, under Week where it has a one, this changes each week.( 1, 2, 3, 4, 5 ) for the week number of the month. On the first week I want (*) to go to 361.00. Are you with me? This is the function I used, =IF(E\$3=1,"",F\$7). You will have to take my word for the 1to be at E3 and the 361.00 to be at F7. When I do this function I am at the first *. If the week number is at 2,3,4,5 I want it to show nothing in those boxes. I hope I am making sense. Can someone help!!

Joined:
Mar 8, 2005
Messages:
19,840
=IF(E\$3=1,"",F\$7) should be =IF(E\$3=1,F\$7,"")
for 2 make it =IF(E\$3=2,next value,"") where next value is the cell containing the value you want for 2.

Joined:
Jul 21, 2005
Messages:
3
I tried that too, The Function itself is showing up in the box I need it to go in.
=IF(E\$3=1,F\$7,"") this is what is in the box!!!!! I know that Its something The operator is doing, but I don't know what .

4. ### Rollin_Again

Joined:
Sep 4, 2003
Messages:
4,912
Is the cell you are entering the function in formatted as text? Sounds like you must format the cell as "General"

Rollin

Joined:
Mar 8, 2005
Messages:
19,840
It worked for me.

Joined:
Jul 21, 2005
Messages:
3
Thank you, It was the fact that I was set to Text instead of general. Thank you so much. All have a great day!!!!!!

As Seen On