Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

excel and the If function

by skeir1964 Jun 18, 2009 3:51AM PDT

I'm trying to use this If funtion
=IF(F6.500,"F6*.25","F6*.10") and all it puts in the cell is .10 instead of putting the calculation of $258.00 * .10 Can anyone help me figure this out...Been at it now for 4 hours!
Thanks, Susan

Discussion is locked

1 Posts

- Collapse + Expand Details

- Collapse -

We will have a go,

by MarkFlax Forum moderator Jun 18, 2009 6:53AM PDT

but will probably need some more information, eg the contents of cell F6.

However, I see an immediate problem.

Your formula, =IF(F6.500,"F6*.25","F6*.10")

Should it be =IF(F6=500,"F6*.25","F6*.10")
{notice the = sign before the 500}. With the correction, if F6 holds 500, then the result is displayed as F6*.25

However, if F6 holds anything else, then the result is displayed as F6*.10

Is that what you are hoping for? If so, no need for us to know what is in F6.

Just one thing though. You may want to error trap the formula. For example, if I input a non-number, like - Mark - into F6, I get the result F6*.10 . Not sure if that is what you would want.

Does that help?

Mark