From everything I've read, you should be able to enter up to 7 variables in 1 "if" statement. I'm just trying to do one with 3, but every time I do, it tells me it's too many arguments. Obviously I'm doing something wrong! Any thoughts?
=IF(B6="NO",A6,0,IF(B6="YES",A6,A6,IF(B6="USE",A6,A6)))
There are only 3 parts to IF function:
IF(evaluation expression, values if true, value if false)
but you may nest IF functions. I do not understand what your formula is attempting - it appears to evaluate to =A6. May you explain in words what you want to do, please?
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
lets assume thats just a test to try out nesting IF
and you want the cell to = value in a6 if it is no,yes or use and = to 0 if none of those conditions are met
then you would construct it like this
=IF(B6="NO",A6,IF(B6="YES",A6,IF(B6="USE",A6,0)))
but there are shorter ways to do that
eg
=IF(OR(B6={"yes","no","use"}),A6,0)
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
I'm trying to create a tax chart that can differenciate different tax rates
Column A is a pretax amount
Column B is to show if it is taxed normal,exempt or use tax (answered by either yes, no or use)
Column C is the taxable amount (where I tried to enter the formula)
Column D is the standard tax amount (column C x my standard tax rate)
Column E is the use tax rate (column C x my use tax rate)
Column F is the total of column C and D or E, depending on which tax rate
Hopefully this makes sense
On taking another look at this, I think column C needs to be split into two columns, one for regular tax and one for use tax. So that would completely change the formula set up, but I still can't seem to make it do what I'm trying.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks