IF Function Queston

[al97233]

I currently have the following formula:
=IF($X$41<10,$X$43*AG70*$V$62,IF($X$41>9,$X$43*AG70*$V$63))

I would like to add a formula that if $X$43 is less than 1 use $CG$43 (this cell contains a sum of other cells). If $X$43 is greater than 1 than use the formula as it is.

Any ideas how i can achieve this?

 

[Desu Nota from Columbus]

are both of these equations suppose to be in one cell?

Can you list out the criteria you want, and maybe a short example of what is suppose to happen?

 

[al97233]

Can I Post or send you a copy of the spreadsheet?

 

[Desu Nota from Columbus]

You can post it using excel jeanie (google it)

 

[Zaigham]

Try this

=IF($X$41<10,$X$43*AG70*$V$62,IF($X$43>1,$X$43*AG70*$V$63,$CG$43*AG70*$V$63))

 

[Zaigham]

Oops. I have missed a little try this

=IF($X$41<10,$X$43*AG70*$V$62,IF(AND($X$41>9,$X$43>1),$X$43*AG70*$V$63,$CG$43*AG70*$V$63))

 

[al97233]

Zaigham you are a life saver. Thanks!!

 

[Zaigham]

Thanks for feedback. You are welcome.

 

[al97233]

=IF($X$41<10,$X$42*AG66*$V$58,IF(AND($X$41>9,$X$42>1),$X$42*AG66*$V$59,$CG$42*AG66*$V$59))

I cannot figure out why the above formula does not seem to work when cell $X$41 is less than 10. If cell $X$42 has a number in it and Cell $X$41 is less than 10 it calculates fine but if $X$42 has no number it will not use the number contained in cell $CG$42. It will use cell $CG$42 if $X$41 is 10 or greater and $X$42 has no number in it.

Help!

 

[Desu Nota from Columbus]

=IF($X$41<10,$X$42*AG66*$V$58,IF(AND($X$41>=10,$X$42>1),$X$42*AG66*$V$59,$CG$42*AG66*$V$59))

Your formula does not say anything to the extent of if $X$41<10 and $X$42 is blank, use number contained in $CG$42.

It says if less than 10 do this: $X$42*AG66*$V$58

If greater than or equal to 10 and X42 greater than 0, do this: $X$42*AG66*$V$59,$CG$42*AG66*$V$59