IF function, nested with 2 source cells?
I think you want something like this:
=IF(C22<0,C10,IF(C220,C33,IF(C29C25,C10,C33)))
Hope this helps.
Pete
On Jul 22, 9:23*pm, Patrick R <Patrick
wrote:
Hi, This may be simple, but I'm trying to assign a % to a sales item, but I
ma having issues:
The value of cell C33 is 30%, the value of C10 is 46%
If I use the formula =IF(C220,C33,C10), provided that the value of C22 is
greater than zero, the result is C33. *That all works fine.
If I use the formula =IF(C29C25,C10,C33) in the next cell, I can assign
those %s according to the value in Cell C25. *That works fine on its own.
|