Use of an IF formula to use a certain formula depending on the value in a cell

[FraserMc97]

Hi

I am wondering whether it is possible to use an IF formula to use one of two formulas depending on whether a cell is equal to 0.5 or not 0.5. I am just wondering whether this is possible because so far when I have tried it has just written the formula in the cell rather than working it out.

Thanks

[Special-K]

You may have put the formula in quotes - remove the quotes.
Or if ALL formulas are displaying formulas rather than results press Ctrl and ` to switch between formula display and results display.

From what you've said base something on this.
Assume the two original formulas are

A1* 3
and
B1 * 5

Then

IF(C1=0.5,A1*3,B1*5)

Replace the above formulas with those of your own

[PFDave]

Hi Fraser you certainly can

Please Login or Register  to view this content.

If you can shed a bit more light on what the two formula options are and which cell row or columns you're checking to see if it's 0.5 I will write the full line for you

Regards

Dave