Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default If and Round Functions


Can someone tell me how to use the if and round functions together. My
if functions is =IF($A5<1,K5-(K5*$A5),K5-$A5) and I need my answers to
be round to the nearest hundred.


--
billykiller05
------------------------------------------------------------------------
billykiller05's Profile: http://www.excelforum.com/member.php...o&userid=36813
View this thread: http://www.excelforum.com/showthread...hreadid=565206

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,624
Default If and Round Functions

One way:

=ROUND(K5-IF($A5<1,K5*$A5,$A5),-2)


In article
,
billykiller05
wrote:

Can someone tell me how to use the if and round functions together. My
if functions is =IF($A5<1,K5-(K5*$A5),K5-$A5) and I need my answers to
be round to the nearest hundred.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,572
Default If and Round Functions

Try this:

=IF($A5<1,ROUND(K5-(K5*$A5),2),ROUND(K5-$A5,2))

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"billykiller05"
wrote in message
news:billykiller05.2bk78s_1153928416.0754@excelfor um-nospam.com...

Can someone tell me how to use the if and round functions together. My
if functions is =IF($A5<1,K5-(K5*$A5),K5-$A5) and I need my answers to
be round to the nearest hundred.


--
billykiller05
------------------------------------------------------------------------
billykiller05's Profile:
http://www.excelforum.com/member.php...o&userid=36813
View this thread: http://www.excelforum.com/showthread...hreadid=565206


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
Round time maybe this explanation will help Darts Excel Discussion (Misc queries) 1 March 22nd 06 10:57 PM
ROUND or "Precision as displayed"? bb Excel Worksheet Functions 2 March 2nd 06 05:53 AM
Round a number in nested function kim Excel Worksheet Functions 1 July 6th 05 11:45 AM
Round whole numbers up and down JoeBed Excel Discussion (Misc queries) 4 July 5th 05 05:21 PM
How do I ROUND() round off decimals of a column dataset? Højrup Excel Worksheet Functions 2 January 12th 05 11:50 AM


All times are GMT +1. The time now is 02:30 PM.

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

About Us

"It's about Microsoft Excel"