- Joined
- Jul 11, 2012
- Messages
- 2
- Reaction score
- 0
Hi, very quick and probably easy to fix problem i am having with a multiple IF formula.
=IF(F8=B2,"$280",IF(B2<=B3,"$420",IF(F8>=B4,"Paid Per Deal")))
I want to show three scenarios, the first two sections of the formula work, however when the selection is true for the follwoing section of the formula IF(F8>=B4,"Paid Per Deal" it doesn't change and continues to show "$420".
any help is very much appreciated.
Regards,
Richard
=IF(F8=B2,"$280",IF(B2<=B3,"$420",IF(F8>=B4,"Paid Per Deal")))
I want to show three scenarios, the first two sections of the formula work, however when the selection is true for the follwoing section of the formula IF(F8>=B4,"Paid Per Deal" it doesn't change and continues to show "$420".
any help is very much appreciated.
Regards,
Richard