IF formula error

R

richard_brown4

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SORT data containing formula 5
formula for changing a percentage 1
Help with formula 2
Formula for subtracting from same number 5
LOOKUP or IF-THEN stmt - which one? 8
Imposs? Speed up 1
complicated if function 3
Easy Nested IF formula question, please help 3

Top