Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have this formula typed into a cell:
=IF((C10+B26)180,C10+B26-360,C10+B26) AND...it works fine; however, I have to add the following parameter to the same cell: = IF((C10+B26)<180,C10+B26+360,C10+B26) Please notice the subtle differences..I am working with a global 360 degree sphere wherein when values are combined, I can be maxed at positive (+179.999) degrees or minimized at negative (-179.999) degrees. I tried the "OR" function outside my "IF" function, but all I got was "TRUE" for the answer..not an actual number. PLEASE OFFER THE CORRECT FORMULA. Thank you, FLKulchar |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formula/functions for average and if functions | Excel Worksheet Functions | |||
XL2003 FILTER FUNCTIONS VS. XL2007 FILTER FUNCTIONS | Excel Worksheet Functions | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Looking for a site with functions that substitute the ATP functions | Excel Worksheet Functions | |||
Nesting functions in the functions dialog box | Excel Worksheet Functions |