Multiple formulas

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
 
J

JulieD

Hi Trudie

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

Cheers
JulieD
 
G

Guest

I have tried this formula but it comes up with an error
stating to many arguments, any suggestions??
 
T

Trudie

I have tried this formula, however it comes up with an
error stating to many arguments. Any suggestions??
 
J

JulieD

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
 
A

Aladin Akyurek

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Formulas 2
Copy Excel Function from a Cell Through a Function 0
look up, match index? multi variable formulas 1
Data Reporting to a cell 0
Formula Help 0
Getting a formula to reflect added columns 10
Macro Relative Cells 3
Pls Help - blank cell/formula issue 7

Top