Multiple formulas

  • Thread starter Thread starter Trudie
  • Start date Start date
T

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
 
Hi Trudie

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

Cheers
JulieD
 
I have tried this formula but it comes up with an error
stating to many arguments, any suggestions??
 
I have tried this formula, however it comes up with an
error stating to many arguments. Any suggestions??
 
Hi trudie

it works fine for me - ensure that it is all on one line with no breaks etc
=IF(C11="Petrol",G11*0.2/6.714,IF(C11="Entertainment",G11/2,L11))
if it still doesn't work, copy & Paste your exact formula into a reply post.

Cheers
JulieD
 
The OP's spec: "if C11="Entertainment" divide column by 2" seems to me
underspecified: Divide WHAT by 2?
 
Back
Top