> >
>

# excel fomula help!

#1
04-18-09, 05:00 PM
Member
Join Date: Apr 2009
Location: KC
Posts: 80
excel fomula help!

The following is an excel formula that is not exactly what I want it woks and it close to what I want

=IF((\$B57*\$C\$12)<100,100,IF((\$B57*\$C\$12)>100,(\$B57*\$C\$12)))

What I really want to say is

IF B27*\$C\$12 = 0,0

IF((\$B57*\$C\$12)> 1 but <100,100

IF((\$B57*\$C\$12)>100,(\$B57*\$C\$12)))

Can anyone help ? I will need it including ( ) placed correctly

#2
04-18-09, 08:43 PM
Member
Join Date: Jan 2009
Location: Central Ohio
Posts: 51

What is the formula trying to do?

#3
04-18-09, 09:36 PM
Member
Join Date: Jan 2009
Location: Central Ohio
Posts: 51
Think I understand it now..

Few options..

1. A cleaned up version of what you started.
=IF((\$B57*\$C\$12)=0,0,IF((\$B57*\$C\$12)<100,100,(\$B57*\$C\$12)))

-or-

2. A "vlookup" formula

#4
04-19-09, 05:45 AM
Member
Join Date: Apr 2009
Location: KC
Posts: 80
Thats exactly what I needed. It appears where i screwed up was in the last statement not the 1st. For 3 days I was working uner a false assumption. What was confusing is the origonal formula actually did what it stated.

Thanks for the help, I really appreciate it.

#5
04-21-09, 09:28 PM
Member
Join Date: Jan 2009
Location: Central Ohio
Posts: 51
No problem!

I love working with Excel. The fact that you can get instant feedback on it working or not is the best.

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off