Multiple Formulas

[Arvi Laanemets]

Hi

=IF(OR(G11="Petrol",G11="Entertainment",G11*IF(G11="Petrol",0.2/6.714,1/2),L
11)

 

[Trudie]

I have set up a formula for expenses
=if(C11="Petrol",G11*0.2/6.714,L11) now this works
however I need to add an additional formula to this
stating the if C11="Entertainment" divide column by 2.

How can I add this onto the orignal formula.

Any ideas???
Thx
..

=IF(C11="Petrol",G11*0.2/6.714,IF (C11="Entertainment",G11/2,L11))

I have tried the above formula however it states that
there are too many arguments, any ideas???

 

[Gary Thomson]

Hi,

The formula should read:

=IF(OR(C11="Petrol",C11="Entertainment"),G11*IF
(C11="Petrol",0.2/6.714,1/2),L11)

Note the ")" after "Entertainment", and some of the G's
should be C's

Alternatively, the formula could read:

=if(C11="Entertainment",G11*0.5,if
(C11="Petrol",G11*0.2/6.714,L11))

Which makes it clearer what is happening.

Happy to help,

Gary Thomson