|
|
#2
02-28-2022, 02:52 PM
|
||||
|
||||
Check your calculations; cell P2 is calculated one way, but cell P5 is calculated differently:
You have in cell P5: =(F5/21*31)+(G5/4*30) which becomes >70k. The 2 cells for March and April contain 7k and 8k, which only add up to 15k. How can you get 70k from those 2 cells? I think your formula in cell P56 should be: =(F5/31*22)+(G5/30*4) which calculates to 6,034.41 , is that correct? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Return value base on two columns | yewee | Excel | 5 | 02-13-2017 03:16 AM |
| finding variations in the data base | adryan | Excel | 4 | 07-15-2015 12:19 AM |
 Creating small data Base
|
quintinros | Excel | 2 | 06-26-2014 12:28 AM |
| Calculate formula base of list menu | rkeles | Excel | 4 | 09-22-2010 12:38 AM |
| Calendar Base | prayojana | Project | 0 | 11-12-2007 01:13 AM |
Windows 10 
Office 2019
Threaded Mode