LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default Combining formulas

I am trying to combine the =MIN formula with the IF function.

I am using =MIN(A1, B1)*1.4 to have the cell show the result of the lowest
of two cells multiplied by 1.4. Right now, if one cell is empty, the
function still chooses the number in the occupied cell.
I would like to add in an IF function that if BOTH cells are empty, then the
cell should display "0.01". This saves me from going back and editing those
cells by hand.

Any ideas?
 
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
Combining 2 Formulas Joker Excel Discussion (Misc queries) 1 February 1st 07 03:30 PM
Combining formulas Krista Excel Discussion (Misc queries) 11 June 27th 06 03:13 AM
Combining two formulas edwardpestian Excel Worksheet Functions 4 June 4th 06 10:23 AM
Combining formulas ben simpson Excel Discussion (Misc queries) 3 March 17th 06 03:49 PM
Combining 2 Formulas carl Excel Worksheet Functions 2 February 2nd 06 06:21 PM


All times are GMT +1. The time now is 08:15 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"