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?

 

[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))

If the number in $X$41 is less than 10 than multiply $X$42*AG66*$V$58
If the number in $X$41 is 10 or greater than multiply $X$42*AG66*$V$59
If the number in $X$41 is less than 10 and $X$42 has no number than multiply $CG$42*AG66*$V$58
If the number in $X$41 is 10 or greater and $X$42 has no number than multiply $CG$42*AG66*$V$59

I hope this makes sense. You people are far more knowledgeable than I am and the more I think about it the more my head hurts.

 

[Jonmo1]

The formula I posted in #15 does just that, except the AG66 (which was not mentioned in your post#14 description)..
And also the variance of X41 = 10 exactly.
And I left out all the $

Try

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

 

[al97233]

JonMo1
That seems to have done the trick!
Thanks for all of your help and patience!