Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

On Tue, 21 Dec 2004 17:01:02 -0800, pflynn
wrote:

I am trying to write a formula in which it can figure the following if a cell
is between 91% and 99% then it should multiply by 1.25 if it is not then it
should equal 0



=A1*1.25*AND(A10.91,A1<0.99)

or, if you are testing A1 to see whether to multiply some other cell (B1) by
1.25:

=B1*1.25*AND(A10.91,A1<0.99)


--ron
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Displaying numbers used in formula SeeFar Excel Discussion (Misc queries) 2 December 28th 04 07:05 PM
Help creating a formula, pulling from a set of static numbers. James Excel Worksheet Functions 1 December 20th 04 06:39 AM
Formula to calculate only the negative numbers Dawn Boot-Bunston Excel Worksheet Functions 5 November 24th 04 09:57 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM
Display numbers only, no text formula Mira Excel Worksheet Functions 2 November 11th 04 01:54 AM


All times are GMT +1. The time now is 09:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"