Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 18
Default Formula

Example:

CELL B13 = 188370
CELL C13 = 349986
CELL D13 = 1.5355*C13

I need a formula that goes in CELL D13 that will use the current calculation
unless it goes above 150% of cell B13, if it does go above the 150% it needs
to use 150%*B13

ANY HELP IS GREATLY APPRECIATED!

 
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



All times are GMT +1. The time now is 12:17 AM.

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"