Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
ALFONSO
 
Posts: n/a
Default how to use if function to calculate common cost in income stateme.

I have a owner who only wants to receive his common cost if the business
earns a profit. ( Net income 0). I used th e absulet value of the net income
sell 0,then the owners percentage time the gross profit for my true
statement and if false 0.
This function althought yielding the correct result will not correctly
populate or change the common cost cell if Groos sales change the amount of
net income to 0.
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
If, Then Function Dee Excel Worksheet Functions 5 July 19th 05 11:48 PM
Function to calculate the number of years, months and days between Vicky Excel Worksheet Functions 2 July 15th 05 04:27 AM
Function Won't Calculate -- Sometimes Bill Martin -- (Remove NOSPAM from address) Excel Discussion (Misc queries) 4 April 13th 05 04:38 PM
Need a ISWorkday Function -- Any Ideas Mark Excel Worksheet Functions 5 March 29th 05 01:58 AM
How to calculate PMT function Daniel Excel Worksheet Functions 1 November 18th 04 08:42 PM


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