A Arvi Laanemets Aug 27, 2004 #1 Hi =IF(OR(G11="Petrol",G11="Entertainment",G11*IF(G11="Petrol",0.2/6.714,1/2),L 11)
T Trudie Aug 27, 2004 #2 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)) Click to expand... I have tried the above formula however it states that there are too many arguments, any ideas???
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)) Click to expand... I have tried the above formula however it states that there are too many arguments, any ideas???
G Gary Thomson Aug 27, 2004 #3 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
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
